What should you do?

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?

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.



Leave a Reply 1

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


Daniel

Daniel

The question doesn’t specify that there are two correct answers, is it ok?