Microsoft
70-432 · Question #132
70-432 Question #132: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #132. The question stem and answer options stay visible for context.
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.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.