You work in a&_睦霖题库

单项选择题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.

热门试题