How to check missed jobs due to downtime?

  • Hi, we have a lot of jobs that run everyday. Due to server downtime or restart, some jobs missed their scheduled. how am i going to all the jobs that did not run at the specified schedule? I was thinking to check the next run date but may be there is a better solution.

    Thanks,

    Marlon

  • You can find this in msdb.sysjobhistory table

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply