Microsoft
70-450 · Question #48
You maintain a SQL Server 2008 instance. You have an existing database maintenance plan that performs the following tasks: You need to ensure that an e-mail message is sent to the operators when the…
The correct answer is C. The SQL Server Agent job. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 instance. You have an existing database maintenance plan that performs the following tasks:
You need to ensure that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully. What should you modify?
Options
- AThe instance.
- BThe SQL Server service.
- CThe SQL Server Agent job.
- DThe database maintenance plan.
How the community answered
(50 responses)- A6% (3)
- B14% (7)
- C78% (39)
- D2% (1)
Community Discussion
No community discussion yet for this question.