COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
After you create the job, SQL Server stores the job definition in which database, choose one
|
|
the sqldb
|
|
|
the msdb
|
|
|
the dbo
|
|
|
the master db
|
Explanation:
Detailed explanation-1: -The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. For example, SQL Server automatically maintains a complete online backup-and-restore history within tables in msdb.
Detailed explanation-2: -SQL Server Agent jobs are stored in the msdb system database.
Detailed explanation-3: -The msdb database file (msdb. mdf) and msdb log files (msdb. ldf) are located in the Program FilesSQL Serverdirectory. Due to the amount of configuration information stored in the msdb database, the database should be routinely backed up.
There is 1 question to complete.