You are your company’s SQL administrator. Your company has several SQL Server 2008 computers that youmanage.
One of the SQL Server 2008 computers named SQL5 is configured with dozens of jobs.
While performing routine maintenance, you decide that a job named ProdDBBackup is no longer needed. Youdisable the job’s schedule.
The next day, you discover that several important maintenance jobs did not run.
You need to ensure that these jobs run as scheduled, but that the ProdDBBackup job does not run.
What should you do?
A.
Re-enable the schedule and disable the ProdDBBackup job.
B.
Detach the schedule from the ProdDBBackup job.
C.
Disable the ProdDBBackup job.
D.
Re-enable the jobs that must be run.
Explanation:
You should re-enable the job schedule and disable the ProdDBBackup job. You can create a schedule in ObjectExplorer and attach that schedule to one or more jobs. When you disable a schedule, the schedule will not be ineffect for any job attached to the schedule. In this scenario, you disabled a schedule, and the schedule will nolonger be in effect for any jobs attached to that schedule. Re-enabling the schedule will allow all the jobs attachedto the schedule to run accordingly. Disabling the ProdDBBackup job will prevent that specific job from running,but still allow other jobs using the same schedule to run at the desired times. Alternatively, you could detach the ProdDBBackup job from the schedule to prevent the job from running per the schedule. If the job is detachedfrom the schedule, the job can still be run manually or in response to an alert. You should not detach the schedule from the ProdDBBackup job. This solution would only work if you also re-enabled the schedule. Although you should disable the ProdDBBackup job to prevent the job from running, you would also need to re-enable the schedule to ensure that the other jobs attached to that schedule run at the desired times. You should not re-enable the jobs you need. The jobs are not disabled. The problem is that the schedule that is attached to the jobs has been disabled.
Objective:
Maintaining SQL Server InstancesSub-Objective:
Manage SQL Server Agent jobs.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > AutomatingAdministrative Tasks (SQL Server Agent) > Implementing Jobs > Creating and Attaching Schedules to Jobs