You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance contains multiple SQL Server Agent jobs. These SQL
Server Agent jobs use twelve shared schedules that are used at all times. There is one schedule
for each month. The schedules are named January, February, etc. each configured to run in a
specific month.
You have been asked to make sure that the ABC_job13 is never run in April. What action should
you take?
A.
You should consider creating a separate schedule for April.
B.
You should consider creating another April schedule for ABC_job13.
C.
You should consider deleting the schedule for April from ABC_job13. *
D.
You should consider deleting ABC_job13 from the April schedule.
E.
You should consider deleting all the scheduled tasks for April.
Explanation:
Just remove the April scheduled from job ABC_job13.