Run sql agent job based on time zone

Question

Post reply

Run sql agent job based on time zone

dba321

Hall of Fame

Points: 3917
More actions
January 16, 2006 at 4:32 pm

#103046

How can I tell the scheduler to run at certain times for specific time zones in SQL Server 2000? I don't see a time zone option, just daily, weekly, etc. then times

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

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

philcart SSC-Forever Points: 47796 More actions · Answer 1

Hmmm ... last I looked there was only 1 timezone on the server.

Maybe if you explain what you're trying to achieve we could take a stab at a solution for you

--------------------
Colt 45 - the original point and click interface

Sergiy SSC Guru Points: 110208 More actions · Answer 2

Set scheduler to run an SP every hour (every n minutes if you need) and within that SP check UTC time and run appropriate task depending on the time zone.

_____________
Code for TallyGenerator

Giles McArdell SSC Eights! Points: 875 More actions · Answer 3

Look up GETUTCDATE() in BOL, this gives GMT whatever the computers local time zone.

"Don`t try to engage my enthusiasm, I don`t have one."

(Marvin)