UK daylight saving and scheduling jobs

• Fishbarnriots

  SSCrazy

  Points: 2568

  More actions

  November 2, 2010 at 9:50 am

  #228705

  Hi,

  Need a few pointers please. I have a SQL task that runs every 10 seconds, this task is used to populate business critical data.

  When the clocks in the UK changed from BST to GMT at 01:59:59 on 31 October 2010 the job did not run for an hour. (At 01:50:50 (BST) the next scheduled run time was set to 02:00:00 (BST), between 01:50:50 and 02:00:00 (BST) the server time was reset to 01:00:00(GMT), oh dear!)

  Does anyone have a solution for me??

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  November 2, 2010 at 11:39 am

  #1245589

  perhaps put the code into a never ending loop with a waitfor '00;00;10' in it, and the job kicks off on server start only?

  As for getting that hour back, no can do. Have you tried DBCC timewarp 🙂

  ---------------------------------------------------------------------