You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?()
- AFor the SQL Server Agent, you should enable a fail-safe operator
- BYou should modify the database maintenance plan, making it send an e-mail to the appropriate operators
- CYou should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators.
- DYou should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.