Sample Header Ad - 728x90

How can we prevent Agent Jobs running twice when the clocks change?

8 votes
6 answers
3006 views
## Context I have no idea where this is documented and was shocked that I could not find a duplicate. I only know it from seeing it go wrong several years in a row. ## The Problem On the day when the clocks go back an hour, SQL Server will repeat any Agent Jobs that run at a fixed time each day. This means that if I have a job run at 01:05 each day, then it will run twice in the same day if the clocks go back an hour at 02:00. Is there any means within SQL Server Agent to prevent this? [It appears that AWS EventBridge Schedules can do it](https://docs.aws.amazon.com/scheduler/latest/UserGuide/schedule-types.html#daylist-savings-time) . The Q & A https://dba.stackexchange.com/questions/189663/daylight-saving-time is related, but their jobs run on a regular frequency (once every 15 minutes). Mine runs at a specific time. The problem has been witnessed several years in a row across more than one server.
Asked by J. Mini (1235 rep)
Oct 27, 2024, 09:00 PM
Last activity: Nov 3, 2024, 01:32 PM