The Database Maintenance Plan Wizard automates many of the common jobs a DBA normally performs. Before this wizard was developed, many DBA jobs were script based. With this wizard, however, you can now graphically automate backups, DBCC commands, and other administrative functions. A nice feature of the Database Maintenance Plan Wizard is that it can email results to an operator.
The following steps explain how to use the Database Maintenance Plan Wizard:
From the SQL Server Enterprise Manager, click the Run a Wizard toolbar button. The Select Wizard dialog box appears (see Figure 12.30).
Figure 12.30. The Select Wizard dialog box.
From the Select Wizard dialog box, Click the plus (+) sign next to the ...