Share via

SQL Server Agent - Retrying When Job Does Not Start

Josh K 81 Reputation points
2020-08-18T15:02:08.537+00:00

Using SSMS 18. I know I can use the Retry Attempts option to retry a job if it fails. What I'm wondering is whether there is a way to retry a job if it hasn't run at all. For example, I had a job scheduled to run a few nights ago but the server was being rebooted at the time the job was scheduled, so it didn't run at all. The scheduled run was skipped. Is there a way to set this up to retry if the scheduled run has been missed?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,340 questions
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sreekanth Madambath 86 Reputation points
    2020-08-18T15:33:16.02+00:00

    Hi Josh,
    I don't think so that you can schedule/retry like that if the schedule is skipped by any reasons.
    As a work around, you may configure another job which runs in some interval to initiate the jobs which was missed schedules.

    If this helps please vote and mark as answer.

    0 comments
  2. tibor_karaszi@hotmail.com 4,306 Reputation points
    2020-08-18T17:41:34.217+00:00

    No, I can say for sure that there is nothing like that built into Agent. You have to roll your own, something like already suggested in other answer.

    0 comments
  3. Tom Phillips 17,721 Reputation points
    2020-08-18T18:39:56.447+00:00

    I have used a method like this to detect missed jobs during downtime. I do not auto run missed jobs, because sometimes it is not necessary.

    https://www.sqlshack.com/detecting-and-alerting-on-sql-server-agent-missed-jobs-2/

    0 comments
  4. Josh K 81 Reputation points
    2020-08-18T18:52:31.447+00:00

    Thanks, all. Sounds like it may not be worth the effort, as I check the Job Agent first thing every morning anyway, so something that generates an email isn't really going to do much more than that for me. I appreciate the quick responses.

    0 comments