which implementsthe stored procedure; however it should delete the job when it is finished.What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
The SQL Server 2008 instance has a stored procedure which runs a database maintenance process.
You were instructed to develop a SQL Server Agent job which implements
the stored procedure; however it should delete the job when it is finished.
What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
The SQL Server 2008 instance has a stored procedure which runs a database maintenance process.
You were instructed to develop a SQL Server Agent job which implements
the stored procedure; however it should delete the job when it is finished.
What should you do?

A.
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.

B.
You should consider developing a Transactions Log to run twice on a schedule.

C.
You should consider developing a job that uses the automatically remove job option.

D.
You should consider developing a job which belongs to the Database Maintenance category.



Leave a Reply 0

Your email address will not be published. Required fields are marked *