Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Clocks go forward

    I have a SQL database running on a Win2K server which runs happily, I think there has been a 99.99% uptime on it and it is service packed and is a smooth running system. It is clustered with another SQL server.

    I have a series of jobs set up, some running at 0100hrs every day and a back up running at 0200hrs on a Sunday morning. These jobs have been happily co-existing for a year or so and are monitored by a system called SolarWinds which polls various servers. I have created a little Excel application that graphs a minute by minute session count, an exert can be seen below at the time in question.

    It had never occurred to me to worry about the clocks going forward last Sunday but I notice that a temporary blip as users (about 20) were hoofed out at 0200hrs I assume. I say assume as there were no calls for assistance then and when I looked at the server job list it stated that the 0100hrs job ran at 0200 hrs and so did the 0200hr jobs.

    Finally the question. Does the SQL server know to run the 0100 hrs job first before the scheduled 0200hrs jobs and then the 0200 hrs jobs or are they all run at the same time? <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    Jerry

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clocks go forward

    Jerry

    It is for that very reason that canny scheduling persons <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> over the years since NT 3.50 know to avoid scheduling any job for the 0059-0201 slot on a Sunday! If you'd scheduled a task for 01:30, will it run twice on the March Sunday and zero times on the October Sunday? Or what?

    As to your specific question, I suspect there is some deeply-buried and undoubtedly non-documented Microsoft code which deals with the DST transition in the way you describe.

    I must admit to being caught out on the Monday morning following "Daylight Saving Change Sunday", because we have three Dell PCs which (BIOS-) power themselves up automatically at 0900 from a weekend of being powered down. Of course they don't know that the clocks had gone forward until they power themselves up, and Windows resets the time from GMT to DST ... (Another example of the Law of Unintended Consequences?!)

    John
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clocks go forward

    >avoid scheduling any job for the 0059-0201 slot on a Sunday

    I know, I know <img src=/S/grin.gif border=0 alt=grin width=15 height=15> This is what happens when you are bequeathed applications, at every turn I find these little quirks that need to be changed <img src=/S/sad.gif border=0 alt=sad width=15 height=15>, this one crepted up on me and bit me on the bum <img src=/S/flee.gif border=0 alt=flee width=25 height=25>
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •