On SQL Server I used maintenance plan wizard to create three jobs:
Job | Schedule |
---|---|
Job 1 | Every 3 week on Sunday |
Job 2 | Every 3 week on Sunday |
Job 3 | Every 3 week on Sunday |
I want the three jobs to run like so:
Date | Job |
---|---|
Sun 2022-01-09 | Job 1 |
Sun 2022-01-16 | Job 2 |
Sun 2022-01-23 | Job 3 |
Sun 2022-01-30 | Job 1 |
Sun 2022-02-06 | Job 2 |
Sun 2022-02-13 | Job 3 |
And so on. But Job Activity Monitor shows the "Next Run" date for all three jobs as Sun 2022-01-09
. I tried to change the "Start date" of schedules to three consecutive Sundays in the past e.g. Sun 2021-12-19, Sun 2021-12-26 and Sun 2022-01-02 but no joy. Please advise.