SharePoint 2007 and DST Change

Wednesday, 12 March 2008 13:29 by RanjanBanerji

So we all experienced the DST change this past weekend.  Though the government has made DST last longer the basic concept remains the same.  One day in spring the time jumps forward by an hour and then one day in fall it jumps back an hour.  Computer systems have been handling this event for decades.  Even systems that were built ages ago that could not handle the Y2K issue could handle the DST change.

Ah! but not anymore.  SharePoint 2007 has some really cool built-in features (please note the sarcasm).  When the DST change occurs SharePoint is completely clueless of what happened.  We had a few content deployment jobs scheduled to run every minutes.  These jobs took an average of about 5 minutes to run.  After this weekend these jobs started taking an average of about 1 hour and 5 minutes to run.  It was too much of a coincidence for all jobs to start taking an extra hour just after the DST change.

After some analysis I figured I might as well restart the Windows SharePoint Timer Service.  Well that fixed the problem.  Well not really.  What will happen this fall when the DST time switches back?  So I was convinced I made a mistake in building our servers.  I must have missed some patch or hotfix.  Nope, that was not the case.  I came across Microsoft's knowledge base article 938663 which then convinced me that what I was observing is a feature not a bug :-).  The article says:

"The Windows SharePoint Timer service does not update its internal time when Microsoft Windows makes the transition from standard time to DST or from DST to standard time. Therefore, after you apply this hotfix, you must restart the Windows SharePoint Timer service after each transition from standard time to DST and after each transition from DST to standard time. If you do not restart the Windows SharePoint Timer service, timer jobs that you schedule may be delayed. Or, they may fail."

So, let me get this right.  You apply a hotfix then twice a year you go to each SharePoint server and restart it's timer service.  Absolutely amazing.  Obviously a better solution would be to write a script or service to do this for you if you are running multiple large farms.  One more reason some people call SharePoint a development platform ;-)

Tags:   ,
Categories:   SharePoint
Actions:   E-mail | Permalink | Comments (8) | Comment RSSRSS comment feed

Comments

June 8. 2008 18:07

Keith

I guess it would be too much trouble to tie the SharePoint application's time handling into the Windows OS, which already accounts for DST and standard time changes. Furthermore why would any application handle time independently of the OS. I'm not a programmer but isn't that the idea behind reusable code and inheritance concept? i.e. re-use something else that already exists to do the job. Sheesh. Who the hell writes this kind of code? They need to get out of the basement office and fluorescent lights and get some vitamin D.

Keith

November 13. 2010 22:01

pingback

Pingback from bryceleece.wordpress.com

Ashley Tisdale Learned Some Cheerleading Moves From Her Mom! | bryceleece

bryceleece.wordpress.com

November 15. 2010 04:25

pingback

Pingback from bryceleece.wordpress.com

Hot New Trailer: Ashton Kutcher And Natalie Portman In No Strings Attached | bryceleece

bryceleece.wordpress.com

November 19. 2010 14:01

pingback

Pingback from bryceleece.wordpress.com

Ashley Tisdale On The Set Of ?High Stakes? | bryceleece

bryceleece.wordpress.com

November 19. 2010 14:15

pingback

Pingback from cheaphomeideas.com

How To Create Outstanding Results And Be Successful In Life | Cheaphomeideas.com

cheaphomeideas.com

November 23. 2010 13:44

pingback

Pingback from bryceleece.wordpress.com

Wild Gaga | bryceleece

bryceleece.wordpress.com

December 10. 2010 13:02

pingback

Pingback from montereybayjobexpo.com

The DRAM Industry Will Face Reduction | Montereybayjobexpo.com Job Blog

montereybayjobexpo.com

March 27. 2011 19:41

pingback

Pingback from artarthistory.bestinfobank.in

History of japanese art mason

artarthistory.bestinfobank.in

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading