You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. Using the Maintenance Plan Wizard you create an appropriate Maintenance plan. The
Maintenance plan works fine, but it is just that your boss, Miss Tess King, in addition wants an email notification to be sent to you and her when there is a problem with running the Maintenance
plan.
How can you please your boss?
A.
Configure the SQL Server Agent job that runs the database maintenance to send e-mail
notifications to Tess King and you.
B.
Configure the Maintenance plan to contain a Notify Operator task that will e-mail Tess King and
you.
C.
Configure the Maintenance plan to disable a fail-safe operator.
D.
Configure the SQL Server Agent job to enable a fail-safe operator.
Explanation:
Maintenance plans create a workflow of the tasks required to make sure that your database is
optimized, is regularly backed up, and is free of inconsistencies.
The Maintenance Plan Wizard also creates core maintenance plans, but creating plans manually
gives you much more flexibility. In SQL Server 2005 Database Engine, maintenance plans create
an Integration Services package, which is run by a SQL Server Agent job. These maintenance
tasks can be run manually or automatically at scheduled intervals.