Hi,
Our jobs are scheduled daily, via Director, at 1:40AM. In the morning of 10/29/06 (daylight saving time enforced), the job that was running when the time switch was to take place, kept running for about 24 hours and then completed successfully. My question is, when the clock struck 2AM, the server time was clocked back by an hour to 1AM. This would mean that the jobs are not yet scheduled (as per windows scheduler), but jobs are already running (as per DataStage server).
1. What should, ideally, happen in this situation? I am assuming the execution should proceed forward without any glitch since the event has already been triggered and there is no mechanism to trace time and backtrack.
2. Now, after 45 minutes (at the 'new' 1:45AM), will the scheduler kick in again?
gateleys
Daylight saving Time and implications
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's what I thought. But, for some reason the jobs that were running during the 'time switch' kept running till the next day. They seem to run fine now, without any tweaks. The fact that there were 4 jobs running concurrently..and all of them behaved the same way, and at about 2PM, caused me to think that it could not have been due to any other cause. Besides, these jobs have been running smoothly for the past 4-5 months.
gateleys
gateleys
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am