December 4, 2008 at 10:11 am
Guys,
My job history has the history only from yesterday only. Where is that settings to clean up that history? I want to keep the history for last 4 weeks. I have the clean up history job also that clean ups history before 4 weeks... Can you please help me where I can fix the settings..
December 4, 2008 at 10:33 am
Don't worry guys it was the setting in the agent properties.. Max rows allowed was 50,000 and when I query msdb.dbo.sysjobhistory then the rows reflected was the same.. I have changed the the max rows allowed to 500000, I have to see if this fix the issue.
Thanks
December 4, 2008 at 10:39 am
50,000 only kept a days history? how many jobs gave you got and how often do they run? Default setting is 1000.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply