Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Why SQL Jobs history getting removed automatically in SQL Server 2005? Expand / Collapse
Author
Message
Posted Tuesday, June 18, 2013 4:32 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 7:41 AM
Points: 323, Visits: 464
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.


_____________________________________________________________________________________________________________
Paresh Prajapati
+919924626601
http://paresh-sqldba.blogspot.com/
LinkedIn | Tweet Me | FaceBook | Brijj
Post #1464558
Posted Tuesday, June 18, 2013 11:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 21, 2014 10:28 PM
Points: 1, Visits: 23
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
Post #1464951
Posted Wednesday, June 19, 2013 7:45 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 12, 2014 7:00 AM
Points: 1,868, Visits: 1,339
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.
Post #1465173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse