Post reply

Missed SQL Server Jobs run after downtimes

  • October 20, 2016 at 3:41 am

    #318281

    I have some SQL Server jobs scheduled between 1:00 AM and 3:00 AM.

    We have server downtime on the first Monday of every Month between 12:00 AM and 4:00 AM.

    How can I ensure that all those SQL Jobs which did not run during this downtime will auto run upon server starts at 4:01 AM on those downtime Monday's.

    Across SQL 2008/2012/2014/2016

    Thanks

  • October 20, 2016 at 4:00 am

    #1907591

    Create a second schedule for each of those jobs that runs on the 1st Monday of the month at something like 4:15 (give time for SQL and SQL Agent to start)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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