Reminder: SQL Server Agent and the clocks going forward

For most of us in the Northern Hemisphere the clocks go foward next month and we get to look forward to longer, sunnier evenings. This post is a reminder that if you have jobs scheduled in SQL Server Agent for the night that happens you may want to check they will not be impacted by the change.

In the UK our clocks change at 1 AM and jump forward by an hour. That means the hour usually between 1 AM and 2 AM doesn’t exist. Any jobs I have scheduled in that time will not happen.

In other countries you may have the change at a slightly different tme – in the US I believe it happens at 2 AM. If you’re in other countries you may need to check what time that happens if you’re not already aware of it.

If you have jobs that need to happen that would normally be scheduled in the “missing” hour then you need to re-schedule them. You may also want to consider permanently moving them to a different time window so you don’t have to worry about it again.

Or even better, you might want to consider having your servers on UTC so you don’t have this problem.

For what will happen in the Autumn when they go back again you can check out this post:

SQL Server Agent and Daylight Saving time

And that concludes this Public Service Announcement!

If this post has helped you, consider buying me a coffee to say thanks.

Leave a Reply