HOW TO: Manage SQL Agent Job History Retention

Within RockSolid you can control how much history is kept within the msdb database on SQL Server.

To configure the job history retention go to the appropriate level in the instance hierarchy where you want to set this policy option.  From there:

  • Choose the Monitoring tab
  • Scroll down until you see Instance Data Retention
  • Enable the SQL Agent Job History Retention option
  • Enter the number of days to keep SQL Agent job history in the "Job History Retention (days):" text box
  • Save the policy

The RockSolid agent will automatically truncate SQL Agent job history data during the monitoring polling cycle going forward.


Have more questions? Submit a request


Please sign in to leave a comment.