Agent Log Clear down

[robert030975]

I'm rather puzzled and can't seem to find what is causing the agent logs only hold a weeks worth of data.

I am aware sp_purge_jobhistory can clear down the log but I'm pretty sure there is nothing of the sort that is running automatically. I have also checked the agent properties which is set to the default properties.

Any ideas Please ?


Thanks

Robert

 

[Crowley16]

have you checked the server agent > job history settings?

--------------------
Procrastinate Now!

 

[mrdenny]

By default the SQL Agent will only store 1000 total records, and 100 records per job. So if you have 10 jobs with one step each, running 10 times per day, you'll only store 10 days worth of data (max).

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog