Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

UTC & daylight savings/standard time

 
   Database Help (Home) -> Notification Services RSS
Next:  notification services -  
Author Message
rand

External


Since: Nov 07, 2006
Posts: 1



(Msg. 1) Posted: Tue Nov 07, 2006 4:54 pm
Post subject: UTC & daylight savings/standard time
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

We manage tasks through NS. We explicitly store our
Subscription.ScheduleStart time as UTC. Perhaps we were convinced from
the documentation that shifts from daylight savings time to standard
(and vice versa) would be handled correctly (I wasn't involved in
initial design). At any rate, with the switch to standard time, all of
our tasks are off by an hour. Not too surprising, a task originally
stored to run at 1:00 AM localtime now runs at midnight, since 0800Z is
still stored. 8:00 AM UTC used to be 1:00 AM local, now it's 12:00 AM
local.

Short of rewriting many layers of our app to perhaps store
ScheduleStart in localtime, how can this be fixed? I can think of a
few options:
a)delete all tasks and reenter; really just a workaround, problem
will occur again in 6 months

b)write a utility to fix-up the entries in NS. Ideally we could
iterate through Subscriptions, adjust the new time, and call Update().

c)some other solution??? We set a magic flag that results in
automatic adjustments to the stored UTC time, based on changing to
standard time. Wishful thinking, this...

Your advice is most welcome.

~rand

 >> Stay informed about: UTC & daylight savings/standard time 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
time event? - Hi, I have some data in my database which stores when a contract expires. I'd like to send a notification 90, 60 and 30 days before the contract will expire. I'm having trouble coming up with a good event to trigger notifications. Do I setup the event...

What is the best way to implement a 1 time match for a Sub.. - I would like to create a subscription that once a Notification is generated for the subscription it becomes disabled. If there a way to do this automatically? If not, any recommendations? FYI.. We do have our own custom formatter and delivery..

Adjusting to user's local time - Hi, I have a notification I'm sending out, and I'm storing an expiration date as UTC. I'd like to format this to the user's local time based on the subscriptions timezone setting. I can figure out how to do this, but I'd be tapping into NS' timezone..

Is the trace flag (8720) needed? - I'm converting SQL7 to SQL2K. The database scripts have an statement: DBCC TRACEON (8720) It's from third party vendor for previous database build or update. I'd like to know if the trace flag 8720 still is needed for SQL 2K or not. If not, I'm going to....

High-level requirement for a pub-sub app - Thank you, Shyam, for your answer to my question regarding the distributor and delivery protocol objects. Your explanation was very helpful to me. Now I have another question for you and the group. I've been given a rough sketch of a possible futur...
   Database Help (Home) -> Notification Services All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]