View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 07:13 AM
tcaylor@thomasnelson.com
 
Posts: n/a
Default SQL Server Agent Job History

I have changed the following setting in SQL Server 2000:
Right click SQL Server Agent and go to properties/Job System and
deselected limit size of job history log. I want to keep all job
histories in msdb indefinitely.

Is there a way to leave this setting on, but configure how much history
shows when you right click an individual job and go to its job history?
In other words, I want to keep all of the job history in msdb, but
only want maybe the last 10 or so to be displayed under right click
job/job history.

Thanks.

Reply With Quote