So far in this book, we have spent a lot of time learning how to use the Maintenance Plan Wizard to create a Maintenance Plan. We've investigated each of the eleven different maintenance tasks it can perform, and discussed how to configure and schedule each task, explaining the many settings that are available for each task.
Along the way, we discovered that much of the power of the Wizard stems from its simplicity. If you want to create a Maintenance Plan that runs a defined set of maintenance tasks the same way for a given set of databases, then the Wizard is a very powerful tool.
However, with its simplicity come certain limitations. One or two of the tasks, notably the
Maintenance Cleanup ...