You maintain a SQL Server 2008 instance.
You have an existing database maintenance plan that performs the following tasks:
-It checks database integrity. -It rebuilds indexes. -It writes a report to a text file.
You need to modify the SQL Server instance such that an e-mail message is sent to the
operators when the maintenance plan fails to execute successfully.
What should you do?
A.
Enable a fail-safe operator for the SQL Server Agent.
B.
Modify the database maintenance plan to e-mail a report to the appropriate operators.
C.
Modify the database maintenance plan to include a Notify Operator task that e-mails the
appropriate operators.
D.
Modify the SQL Server Agent job that executes the database maintenance plan to notify
the appropriate operators.