Scheduled Jobs and Daylight Saving

  • Thread starter Thread starter CL
  • Start date Start date
C

CL

According to http://webexhibits.org/daylightsaving/b.html,
In the U.S., clocks change at 2 am local time. In Spring, clocks
spring forward from 1:59 am to 3 am; in Fall, clocks fall back from
1:59 am to 1 am. In the EU, clocks change at 1 am Universal Time. In
Spring, clocks spring forward from 12:59 am to 2 am; in Fall, clocks
fall back from 1:59 am to 1 am.

What will happen to jobs that are scheduled to run during this time?
Essentially during spring, if I have a job scheduled to run at 2:30am,
it will never run because the clock jumps from 1:59 to 3am.
Similarly, in the fall, if I have a job scheduled to run at 1:30am, it
will run twice. This may lead to not so desirable side effects. Does
it mean that jobs should not be scheduled between 1-3am?

How does the Operating System handle time changes?
 
Hi CL,

It is a very intresting question.

However is it DotNet?

I think that this is a part of the OS and can evem be for every Windows OS
different.

De framework does not manage the system. It can be used to manage the
system.
One of the lacks in my opinion still in dotNet is good support for the
daylight saving systems.
(Otherwise you could make your own scheduler which did keep track on it)

I think it is better to ask this question in a newsgroup special for the
server you are using (what I assume your question is for).

I hope it helps you to find your answer and when you find a nice answer,
please post it back in this thread I am too curious to the answer.

Cor (Also CL)
 
SQL Server schedules the job by marking the date & time when the job
should run next. So, if it's scheduled to run every day at 1:30 am,
once it runs, it will mark that the job should run the following day
at 1:30am. So, during fall, even if the clock falls back, job will
run only once. But, the problem of skipping jobs still exists during
spring when the clock jumps from 1:59 to 3am.

CL
 
Hi CL,

Not that I send you away, however I would ask this question in a SQL server
newsgroup.
 
Not that I send you away, however I would ask this question in a SQL server
newsgroup.
Click to expand...
Which I cannot and even would not, however some people think that this is
sometimes the meaning from a message as this.

Cor
 
Back
Top