O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Before You Create any Maintenance Plans...

Both the Maintenance Plan Wizard and the Maintenance Plan Designer have the ability to send e-mails to DBAs, providing them with information on the status of the Maintenance Plans that have executed. The number of e-mails and their contents vary depending on which tool you use to configure these e-mail notifications.

In the case of the Maintenance Plan Wizard, you can configure an option that will send you an e-mail every time that a Maintenance Plan has been executed, which includes standard information on what plan was run, and what steps were executed, and reports any errors that occurred. Once this option is configured, it will send an e-mail every time the Maintenance Plan is executed, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required