June 18, 2013 at 4:32 am
Why SQL jobs history getting removed automatically in SQL Server 2005 even not configured any user process to remove it?
Also not configured "Current log history log size" for Remove agent history and limit size of history log from SQL Server agent property.
June 18, 2013 at 11:59 pm
This can be due to the limited size of job history.
once go to the Object Explorer -> SQL Server Agent -> Right click on properties -> History
There you can find the limited size of job history log size(in rows).
May be incrementing the value helps your requirement of retaining the job history.
This happens when the new job history is added the previous history will be deleted when the history exceeds the max limit specified.
-------------------------------------------------
Prakash
June 19, 2013 at 7:45 am
Are there any Trace Flags enabled in SQL Server startup parameters? If I recall correctly, there is one that suppresses logging.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply