Online Documentation for SQL Administrator for SQL Server

Managing tasks

Use this tab to create tasks grouped into subplans. Maintenance plans can contain multiple subplans, which are used to hold collections of tasks. Each subplan can be scheduled to run the subplan tasks at different times.

Each maintenance plan must contain at least one subplan.

The grid in the window displays the following information about existing subplanned tasks: Task Name, Enabled, Type, Databases/Objects.

Using the context menu you can:

• Add a new task to the existing subplan
• Insert a new task before an existing one
• Edit selected task
• Delete selected task
• Add a new subplan
• Edit selected subplan
• Delete selected subplan
• Enable Task
• Disable Task
• Move the task up
• Move the task down

Editing subplan means setting its Name and Description.

The following tasks can be added to subplans:

• Backup database
• Check database
• Rebuild indexes
• Reorganize indexes
• Shrink database
• Update statistics
• Execute job
• Execute T-SQL statement
• Notify operator
• Clean up history
• Clean up maintenance log