Online Documentation for SQL Administrator for SQL Server

History


In this section you can view maintenance plan history. It is available only on editing a maintenance plan.

 

Maintenance plans - Maintenance Plan Editor - Viewing maintenance plan history

 

 

The list in the Maintenance Plan History area displays the history of maintenance plans as a grid with the following columns: Maintenance Plan Name, Start Time, End Time, Subplan Name, Run Status, Logged Remotely, Plan ID, Duration, Source Server. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.

 

When you choose a particular maintenance plan the Task Details area displays the following detailed information about the subplanned tasks: Task name, Start Time, Run Status, Duration, Server, Error Number, Error Message, Command, Task Details.

If you select the step with the Run Status value "Failed" then in the lower area you will see the message informing about the reason of the occurred mistake. Otherwise you will see more information about the particular task.

 

Use the History panel on the navigation bar to specify the History date interval.