Why can’t I see more job history?

I’ve been a DBA for a long time… and it still takes me a minute of thinking before I remember how to see more job history.  Furthermore, it takes a second try before I remember that the “Maximum job history rows per job” is the number of steps * the number of job runs. So, if each job run has 100 steps, and your setting (as below) is “200” for the “Max rows per job”, then you’re only going to see 2 job runs in history.
Lastly, don’t forget that other jobs might ‘steal’ history from the job you’re interested in.
Done.

Leave a Reply

Your email address will not be published. Required fields are marked *