Daylight Saving (DST) and SQL Server Scheduled Jobs

Question

Daylight Saving (DST) and SQL Server Scheduled Jobs

Todd Stu

Say Hey Kid

Points: 690
More actions
February 27, 2007 at 1:14 pm

#75132

Hi,
I think I've got a handle on the DST patches.
Has anyone tested scheduled sql server jobs?
I'm assuming any jobs scheduled between '2007-03-11 2:00:00.000' and '2007-03-11 2:59:59.999' will not start.
any insight is appreciated.

Cheers,
Todd

Viewing 10 posts - 1 through 9 (of 9 total)

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

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 1

My "insight" is: it will run. The reasons are, we did not have any such an issue before, nor did we have any job running twice at the end of DST.

MohammedU SSCoach Points: 19644 More actions · Answer 2

How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007

http://support.microsoft.com/default.aspx?scid=kb;en-us;931975&sd=rss&spid=2855

MohammedU
Microsoft SQL Server MVP

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 3

let's hope that every other country doesn't follow suit and start changing this every year!! Has anyone a link which shows what "benefits" are supposed to come from changing the hours? ( I'm just interested as I guess the UK will probably want to follow the US !! )

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Anders Pedersen SSChampion Points: 11410 More actions · Answer 4

I thought this change to US dates was to make us use the same dateas as the EU. At least that was what I got explained to me. Is UK not following the same dates as the rest of the EU?

nigel. SSChampion Points: 11636 More actions · Answer 5

According to these, EU (including the UK) summertime begins on 25th March

http://wwp.greenwichmeantime.com/info/bst.htm

http://wwp.britishsummertime.co.uk/

Nigel
How to post questions

JeremyE SSCoach Points: 16199 More actions · Answer 6

The reason for the DST change is the Energy Policy act of 2005.

http://en.wikipedia.org/wiki/Energy_Policy_Act_of_2005#Change_to_daylight_saving_time

Todd Stu Say Hey Kid Points: 690 More actions · Answer 7

thanks for all that useless information - here are the answers I was looking for:

In Spring, jobs scheduled during the spring ahead hour from 2 - 2:59:59am will launch at 3am (I assume they'll run once).

In Fall, jobs scheduled during the fall back hour (potential to run multiple times) will NOT launch the second occurance of 1am -2am (no jobs run during this repeated hour).

Cheers,

Todd

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 8

hmm, it appears US summer time would have started a week after the uK but will now start two weeks before. The servers I watch over are in an outsourced data centre and most have been set up with US regional settings but on english time ( GMT ) so I wonder which choice they will make < grin >

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 9

You can only have one time zone in Windows set as your active time zone, so it will follow the settings for that.