August 19, 2004 at 9:03 am
Hi, I have about 50 jobs that run daily on my sql 2000 server, about a week ago the jobs had all the prior histories (fail/success). Now over the last few weeks every night they get over written or cleared. yesterday said competed on the 18th now that entry is replaced with completed on the 19th and doesnt retain the 18th's history. The log is set to hold 10000 rows and the job history is set to hold 200 per job. Currently the log has 2000 rows. My question is why is this being cleared or over written every night. I know that no one is logging on to the server and clearing the logs. Anyone have any ideas? I have looked in error logs and find nothing.
Thanks.
Go PATS
August 20, 2004 at 12:23 am
No idea, but this is exactly the reasen why I created a administration database with jobhistory extracted from the msdb database. This extracts the information every night and therefore I have the information I need.
September 1, 2004 at 3:03 am
what about reindex msdb (if you can).. this may solve your problem
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply