Scheduling SQL Agent Jobs on Alternating Weeks

Bi-week… semi-week… fortnight… « every two weeks »

Recently on the SQL Community Slack group, someone asked if there was a way to schedule a backup to run on alternate weeks. I’m not exactly sure why (maybe they wanted to run full and differential backups on alternating weeks), but yes, we can do that. In part one of this two part series, we’ll explore how to do just that via the GUI in SSMS. In part two, we’ll look at how to automate that.

Put it on my calendar

With all of options in the UI, scheduling jobs via the SQL Server