New Microsoft SQL Server Video Tutorial: Pt 4 - Modifying Maintenance Plans

Pt 4 - Modifying Maintenance Plans - view details

One of the most exciting improvements to Maintenance Plans in SQL Server 2005 is the SSIS-based interface that you get when you modify the Maintenance Plans. This interface will allow you to create very intricate Maintenance Plans that go well beyond the wizard's basic functionality. You can add Operator notifications (i.e., send an email to an Operator whenever a Maintenance Plan task fails), add complex error handling or any type of auditing/SQL/etc.

This video is just an overview of how to modify the Maintenance Plans along with a quick walk-through of the drag-and-drop features of the SSIS interface. It does not go too deep, however, since you need some familiarity with SSIS to really expose the more interesting/flexible parts of the Maintenance Plan.

One suggestion: watch this series in conjunction with some of our introductory videos on SSIS to get the most out of your Maintenance Plans.

• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 100 (Beginner)
• Length: 4:43 (6.34MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video