How To Fix The Issue When SQL Jobs Are Running But Not Showing History Records



TODO:

Have you experienced the issue that jobs are running, but you do not see any job history?  This can occur if you have a job that runs at say 3AM, and you have a series of other jobs that run every minute or so during the day.  Those jobs will fill up the Job History, and the entry for the job in question is purged from the history, due to the Maximum History setting.

 

SOLUTION:

1.  Right click on SQL Agent, choose Properties.

2.  Click to History

3.  Increase the value for "Maximum Job History Log Size (in rows)

 

NOTES:

There are no notes on this topic.