YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.Youputforwardadatabasemaintenanceplan.Themaintenanceplanrebuildsindexes,checksdatabaseintegrity,writesareporttoatextfile.Nowthecompanyrequiresthatwhenthemaintenanceplanexecutesabnormally,theoperatorscanbenotifiedbyane-mailmessage.You'vebeenassignedthistask.SoyouhavetomakemodificationsontheSQLServerinstance.Whatshouldyoudo?（）A.For the SQL Server Agent, you should enable a fail-safe operator B.You should modify the database maintenance plan, making it send an e-mail to the appropriate operators C.You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. D.You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

单项选择题

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?（）

A.For the SQL Server Agent, you should enable a fail-safe operator
B.You should modify the database maintenance plan, making it send an e-mail to the appropriate operators
C.You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators.
D.You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

MCTS(70-432)