Maintenance Plan Wizard (Define History Cleanup Task Page)
Use the Define History Cleanup Task page to discard old task history. This task deletes the records of when certain types of jobs occurred.
This statement uses the sp_purge_jobhistory, sp_maintplan_delete_log, and sp_delete_backuphistory statements to remove history information from the msdb tables.
Options
Backup and restore history
Retaining records of when recent backups were created can help SQL Server create a recovery plan when you want to restore a database. The retention period should be at least the frequency of full database backups.SQL Server Agent Job history
This history can help you troubleshoot failed jobs, or determine why database actions occurred.Maintenance Plan history
This history can help you troubleshoot failed maintenance plan jobs, or determine why database actions occurred.Remove historical data older than
Specify age of items that you want to delete.