October 30, 2009 at 6:33 am
can u please advise me y the job history in sql server agent is not retaining for more than 3 days for some job
October 30, 2009 at 8:03 am
I can't verify this, as I don't have access to a SQL2005 instance at the moment, but I'm fairly certain the default is to keep the history for a maximum of 1000 job runs, and a maximum of 100 for any given job.
To change it, you will need to configure this in SQL Agent. I can't give you exact keystrokes (for the reason explained above), but you'll probably find it somewhere if you right-click SQL Agent in SSMS.
October 30, 2009 at 8:09 am
SQL Server Agent -> Properties -> History
October 30, 2009 at 8:26 am
homebrew01 (10/30/2009)
SQL Server Agent -> Properties -> History
Thanks Mr Brew:-)
October 30, 2009 at 10:17 am
campag or shimano mr brew?
---------------------------------------------------------------------
October 30, 2009 at 10:38 am
george sibbald-364359 (10/30/2009)
campag or shimano mr brew?
Mish-Mash of Campy 10. That's my homemade Franken-bike
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply