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
Last activity: Jul 10, 2025, 10:59 AM