History Cleanup Task
When SQL Server Agent runs jobs for a considerable period of time, the job history, which is kept in msdb database tables, can fill up the database with lot of unwanted data. The History Cleanup task enables a package to delete the historical data stored in tables of msdb database for backup and restore activities, SQL Server Agent jobs, and database maintenance plans. The tables of the msdb database that get affected are backupfile, backupfilegroup, backupmediafamily, backupmediaset, backupset, restorefile, restorefilegroup, and restorehistory. Here’s the step by step configuration method for this task:
1. | Connect to the SQL Server while trying to configure this task. This task uses the ADO.Net (SqlClient Data Provider) ... |
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
