Microsoft
70-432 · Question #132
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…
The correct answer is B. Create a job that uses the automatically delete job option. See the full explanation below for the reasoning.
Question
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?
Options
- ACreate a job that is scheduled to run once.
- BCreate a job that uses the automatically delete job option.
- CCreate a job that is assigned to the Database Maintenance category.
- DCreate an Alert that will be raised when the job completes.
How the community answered
(43 responses)- A5% (2)
- B84% (36)
- C2% (1)
- D9% (4)
Community Discussion
No community discussion yet for this question.