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

1,112 reads

Blogs

Giving a Security Webinar this Wednesday

By

If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...

Write to backup block blob device failed. Device has reached its limit of allowed blocks.

By

Picture this, you’re happily backing up your database to a Azure blob storage until...

Comparing Two Scripts with kdiff3

By

I had a customer recently ask if SQL Compare could show them the differences...

Read the latest Blogs

Forums

Error while opening a custom report(.rdl) in SSMS 2017, created in VS 2019

By IT researcher

I'm experiencing difficulties opening a custom report created in Visual Studio 2019 using Microsoft...

activity monitor is showing two diffrent spid for one big stored procedure.

By rajemessage 14195

hi xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng....

Commit transaction inside loops

By PHXHoward

Hello, our users are complaining about blocking during a delete loop so I'm thinking...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers