September 23, 2010 at 3:45 am
I have scheduled a sql 2005 job to run at 1am in the morning,
example:
10-09-10 > I created a job
So the job properties show scheduled for the first run on 11-09-10 , 1 am.
Now, when I checked the job history on 11-09-10 I didnt see any job history for it.
Howver I could see that the last executed date was 11-09-10, but no job history.
Please advice.
September 23, 2010 at 5:15 am
I think the job history entry for 11-09-10 has been removed from msdb database.
Regarding this situation I have following suggestions:
1) Increase the job history log size (right click on SQL Server Agent -> Properties -> History...)
2) For important jobs, setup notification to send you an email
3) To see the history of 11-09-10, restored the backup of msdb to a test server with different name and query it.
4) If this job is created by a maintenance plan, check the log folder. It will have text file report for each execution.
Hope this helps you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply