You need to create a SQL Server Agent job that runs the stored procedure

You administer a SQL Server 2008 instance. You have a stored procedure that implements
a database maintenance process.
You need to create a SQL Server Agent job that runs the stored procedure. You also need to
ensure that the job is removed after successful completion.
What should you do?

You administer a SQL Server 2008 instance. You have a stored procedure that implements
a database maintenance process.
You need to create a SQL Server Agent job that runs the stored procedure. You also need to
ensure that the job is removed after successful completion.
What should you do?

A.
Create a job that is scheduled to run once.

B.
Create a job that uses the automatically delete job option.

C.
Create a job that is assigned to the Database Maintenance category.

D.
Create an Alert that will be raised when the job completes. This Alert will run another job
to delete the maintenance job.



Leave a Reply 0

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