SQL Server Jobs & HA/DR

APPLIES TO: SQL Server Azure SQL Database (Managed Instance only) Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

---

This repository contains scripts to automatically enable or disable specific scheduled jobs on SQL Servers based on the database role in Availability Groups or Database Mirroring.

Download

• ChangeJobStatusBasedOnHADR.sql
• ChangeJobStatusBasedOnMirroring.sql

See Also

• Blog post: Automatically Enable or Disable Jobs based on HADR Role