SQLServerCentral Article

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 […]

You rated this post out of 5. Change rating

2023-11-17

2,050 reads

Blogs

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

FabCon 2025 Recap

By

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...

Privacy Policy

By

We value your privacy. This policy explains what personal data we collect and why. What...

Read the latest Blogs

Forums

why cant i get rid of extra dataset

By stan

hi i never used shared datasets before in ssrs.   i created a dataset  called...

Distinct values using string_agg

By jagjitsingh

Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...

Refactoring a DELETE query using NOT EXISTS — need expert feedback

By abdalah.mehdoini

Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...

Visit the forum

Question of the Day

Importing Flat Files

What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?

See possible answers