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

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *