Online Documentation for SQL Administrator for SQL Server
Clean up history
Use the Clean Up History Task dialog to discard old historical information from tables in the msdb database. This task supports deleting backup and restore history, SQL Server Agent Job history, and maintenance plan history.
The General tab allows you to set common properties for this task. To set relationships between tasks use the Precedence constraints tab.
Name
Enter the task name.
Enabled
Check this option to enable task execution.
Connection
Specify which server connection should be used for task execution. You can choose among existing connections or create a new one.
Remove backup/restore history
Checking this option causes the backup and restore history for the subject database to be deleted from the msdb database.
Remove SQL Server Agent job history
Check this option for SQL Server Agent to remove entries that have been in the log longer than a specified length of time.
Remove maintenance plan history
If this option is checked then the maintenance plan history will be deleted from the msdb database.
Remove history that is older than
Specify age of items that you want to delete.
See also:
