Job History clearing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Job History clearing

Job History clearing

Rate Topic

Display Mode

Topic Options

Author

Message

andymay-496937

Posted Monday, September 24, 2012 8:33 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, October 18, 2012 3:11 PM
Points: 15, Visits: 112

Hi there

I have a SQL Server that clears it's Job History every morning sometime after 5 am. it clears out completely, but I can't find a job of scheduled task that does it. I need the log to work out why jobs are failing so I need to stop it but can't see how it is doing it.

Any help would be much appreciated

Post #1363756

rVadim

Posted Tuesday, September 25, 2012 1:07 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:36 PM
Points: 887, Visits: 2,062

Check agent properties. There should be a chechbox to auto remove job history.

Post #1363820

andymay-496937

Posted Tuesday, September 25, 2012 2:54 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, October 18, 2012 3:11 PM
Points: 15, Visits: 112

Thanks for that, I have checked in the Agent properties>history page and the option to clear the history is not set.

To try to track it I ran a job every 10 mins overnight and the logs are there from 5:10 am so something is clearing the history at 5:00am, but I can't find any jobs or scheduled tasks that run at that time that would clear it.

Post #1364294

george sibbald

Posted Tuesday, September 25, 2012 3:37 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 5,266, Visits: 11,197

under sql agent - properties - history there is also a setting for limit size of job history log. This defaults to 1000 so if you have a lot of jobs, or jobs that run frequently this soon fills, so increase that value.

---------------------------------------------------------------------

Post #1364321

rVadim

Posted Tuesday, September 25, 2012 6:15 PM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:36 PM
Points: 887, Visits: 2,062

Could it be ..
- Maintenance plan;
- External job scheduled in windows;

If I'm not mistaken, job history usually deleted by this procedure: sp_purge_jobhistory. Try to trace who is calling it using profiler.

...Just a few thoughts.

Post #1364384

« Prev Topic | Next Topic »

Permissions