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

Job History clearing Expand / Collapse
Author
Message
Posted Monday, September 24, 2012 8:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, October 12, 2014 4:14 PM
Points: 18, Visits: 148
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
Posted Tuesday, September 25, 2012 1:07 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:16 PM
Points: 990, Visits: 2,223
Check agent properties. There should be a chechbox to auto remove job history.
Post #1363820
Posted Tuesday, September 25, 2012 2:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, October 12, 2014 4:14 PM
Points: 18, Visits: 148
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
Posted Tuesday, September 25, 2012 3:37 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
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
Posted Tuesday, September 25, 2012 6:15 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:16 PM
Points: 990, Visits: 2,223
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 »

Add to briefcase

Permissions Expand / Collapse