Database Maintenance Plan History
Use this dialog box to view the history of database maintenance plans that either have completed successfully or have failed to complete. By default, the history of all plans is shown. To view a subset of the plans, specify the criteria that the plans to be viewed must have. The history of a plan is displayed only if it matches all of the specified criteria.
Options
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 Keywords in 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.
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.
Properties
Display the properties dialog box for the selected database maintenance plan.
Delete
Delete the selected maintenance plan history.
Refresh
Refresh this dialog box with the most current data.