June 16, 2005 at 8:27 am
Hello Friends!!!
We have scheduled jobs running at certain interval and we need to check it frequently history of that jobs. We are doing this by watching it in
Sql Server Agent>jobs>then by right click the job we get menu where we finds job view job history. Till in afternoon that was working fine but in evening what we found is that all job history got cleared automatically for all job!
Can anybody have any idea @ this? How job history got cleared automatically?
Please help me out!!
T.I.A
Shashank
Regards,
Papillon
June 16, 2005 at 10:58 am
They do not disappear by themselves.
They have either been deleted through someone clicking on Clear All button
Or, I there is a setting at sql server agent level where you can define maximum log files allowed.
Right click on sql server agent, Properties, job system tab and maximum job history rows per row. Perhaps a DBA set this to 0.
May 5, 2006 at 9:48 am
It's a SQL Server Agent setting. Right-click on the Agent in EM, select properties, Job System tab. You can choose whether or not to limit the job history log size and what the limit will be.
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply