A wizard included with Microsoft SQL Server version 6.0 and later that lets you configure and schedule core maintenance actions for databases. You can schedule actions such as:
You can use the wizard to schedule maintenance tasks at daily or weekly intervals. You run the Database Maintenance Plan Wizard from the toolbar of the SQL Server Enterprise Manager administrative tool. You can delete or disable scheduled maintenance tasks if they are no longer required.