Database Maintenance Plan History (SQL Server 2000)
When connecting to Microsoft SQL Server 2000 servers, use the Database Maintenance Plan History dialog box to find information about maintenance plans configured on the server. New database maintenance plans cannot be created and some properties cannot be modified with SQL Server Management Studio. Use Enterprise Manager instead. Database maintenance plans cannot be created on Microsoft SQL Server 2005. Use maintenance plans instead.
Filter criteria
Select from the following fields to restrict the displayed database maintenance plans to those plans the meet the criteria.
- Plan name
Specify the name of the database maintenance plan you want to view.
- Server Name
Specify the name of the server containing the database maintenance plan history you want to view.
- Database
Specify the name of the database whose history you want to view.
- Status
Specify the status of the plans whose history you want to view: Succeeded or Failed. If you click Failed, type keywords in the Keywordsin message box to further narrow the scope of the plan histories displayed.
- Activity
Specify the activity of the plans whose history you want to view: Optimizations, Integrity Checks, Database Backup, Transaction Log Backup.
- Keywords in message
Specify the error message keywords for the history you want to view, or view the history of successful backup jobs.
Maintenance plans
The history of the database maintenance plans appear in this box.
- Rows
The number of maintenance plans that met the filter criteria.
- Maintenance Plan
The name of each maintenance plan.
- Server
The name of the server for each maintenance plan.
- Database
The name of the database for each maintenance plan.
- Activity
The name of the activity for each maintenance plan.
- Status
The status returned when the plan executed.
- End Date
The date and time the maintenance plan completed.
- Message
Any message returned from the plan when executed.
- Automatically apply filters
Apply the group of criteria to the entire set of database plans each time you change one of the filter settings. Clear this option until you have set all the filter criteria to your satisfaction. This option is the default.
- Delete
Delete the selected maintenance plan history.
- Refresh
Refresh this dialog box with the most current data.