You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance has a stored procedure named ABC_14. You have been
asked to make sure ABC_14 is run once on April 21 at 5.15 AM only. You create a new SQL
Server Agent Job that starts ABC_14 to run at April 21 at 5.15 AM.
You ask your CEO if you are allowed to use SQL Server Agent Job to implement this. She tells
you that it is ok, but in that case you must make sure the SQL Server Agent Job is removed after
ABC_14 has run.
What actions should you take?
A.
Reconfigure the SQL Server Agent Job to Automatically delete the job when the job succeeds.
B.
Reconfigure the SQL Server Agent Job to Automatically delete the job when the job fails.
C.
Reconfigure the SQL Server Agent Job to Automatically delete the job when the job completes.
D.
Make sure that the job belongs to the Database Maintenance category.
E.
You should consider developing an Alert that will be raised when the job completes.
In addition you should also set the alert to call another job when activated.
F.
Modify ABC14 to delete itself when the job succeeds.
G.
Modify ABC14 to delete itself when the job fails.
H.
Modify ABC14 to delete itself when the job completes.
Explanation: