Post reply

daylight savings time

  • March 9, 2012 at 2:19 pm

    #254528

    How does DST impact SQL Agent jobs that run between 2 and 3am. Let's say I have a backup schedules at 2:30AM. Is it going to run this weekend or will it fail?

  • March 9, 2012 at 2:59 pm

    #1457409

    here is a msdn article for the DST to ST switch (fall Back) and from it i think we can safely guess the jobs wont run. since the time will go from 1:59:59:999<however many 9's you want> to 3:00:00:00 the jobs would never trigger. the fixes would be to schedule the jobs at 3:01:00 or 1:58:00 or turn off the automatic DST switch on your server and manually change the time some time Sunday morning once the jobs had run but before the servers take a lot of traffic.

    http://support.microsoft.com/kb/931975

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • March 9, 2012 at 3:01 pm

    #1457411

    I think the job will simply not run. It won't fail because it won't be attempted. This Sunday, 2:00 AM will not exist.

    _________________________________
    seth delconte
    http://sqlkeys.com

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

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