You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
You want the tasks in the database to have the following characteristics:
* Examining database integrity.
* Reproducing indexes.
* Stores a report to a text file.
You have received instructions to ensure that you could change the SQL Server instance in such a
way that an e-mail notification is sent to the developers when the maintenance plan could not run
normally.
What should you do?
A.
You should consider disabling a fail-safe operator for the SQL Server Agent.
B.
You should consider modifying the SQL Server Agent job so that it runs the database maintenance plan to send e-mail notifications to the developers.
C.
You should consider modifying the database maintenance plan to contain a Notify Operator task that will e-mail the proper developers.
D.
You should consider enabling a fail-safe operator for the SQL Server Agent.
The question doesn’t specify that there are two correct answers, is it ok?