Sample Header Ad - 728x90

How do I maintain a specific cadence in a bi-weekly SQL Agent job schedule?

2 votes
1 answer
76 views
I have a SQL Agent job I need to run every two weeks on specific Saturdays (6/14, 6/28, 7/12, 7/26...). The job failed on 6/28 and when I query sysjobschedules it indicates the next scheduled run date is now 7/5. How do I get this to stay on the original schedule? I assumed it calculated from the Start Date in the schedule but this does not appear to be the case. I tried changing the Start Date in the schedule to 7/1/2025 to see if it would reset, but the next scheduled run date is still showing 7/5/2025.
Asked by Don (377 rep)
Jul 1, 2025, 05:56 PM
Last activity: Jul 10, 2025, 10:59 AM