You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this, you must make sure that after it is completed successfully, the job is removed. <br /> What should you do? ()
A、You should create a job which is assigned to the Database Maintenance category
B、You should create an Alert which will run another to delete the maintenance job.
C、You should create a job. You schedule the job to run only once.
D、You should create a job. The job uses the Automatically delete job option