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
Last activity: Nov 3, 2024, 01:32 PM