SQL Server Tasks / Schedules - Daylight Savings Time Adjustment in USA and UK
We have a UK-based server that needs to start the SQL agent at 16:30 (central US time - this may seem strange, but due to some data). Usually this will not be a problem, because the time difference between the UK and the USA is 6 hours, so we plan our work at 22:30.
But since the UK and the US adjust their watches at different times in March and November to switch to daylight saving time, there is a 2-week period when the time difference between the UK and the USA is 5 hours.
I would like to implement a way in which SQL Server could identify this change in time difference and then redistribute the task to itself using something like sp_update_schedule.
One of my approaches is to get the current timestamp on an American server, and then compare it with the current UK time. If the time difference is 5 hours, then reschedule the task before 21:30, if the time difference is 6 hours, and then reconfigure the task at 22:30.
But in any case, it may offer another solution, perhaps one that would not include obtaining the current timestamp on the American server and, ideally, should not save the list of daylight saving time adjustment dates in the table. Something more dynamic maybe?
source