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


1,131 reads


SQL Server Quickie #46 – SQL Server on Linux


Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Giving a Security Webinar this Wednesday


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.


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

Read the latest Blogs


Dropping a Service from Service Broker crashes server

By dwebb@soundphysicians.com

I'm having an issue trying to drop a service.  When I issue the drop...

SQL MI - SQL Jobs failing with User Manager\ContainerAdministrator.

By DanielP

This is strange, any SQL job that sends out Emails via 'msdb.dbo.sp_send_dbmail ' are...

Tempdb: is it being used?

By dopydb

hi so i have a really old application that is used to process data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers