Database Mirroring

Technical Article

Automatically Failover (Enable or Disable) Jobs Based on HADR Role

  • Script

If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.

5 (1)

2018-11-14 (first published: )

3,301 reads

Blogs

Encrypting Your SQL Data Should be Your Default Option

By

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Power BI Embedded: Using Row-Level Security for Multilingual Reports

By

Making multilingual reports in Power BI requires a lot of different elements. Translations can...

Daily Coping 29 Nov 2022

By

Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

Read the latest Blogs

Forums

Sql table join help

By SQL Bee

I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101,...

Why do Sql Server In operator behaves differently and return nothing?

By mehmood

I am using sql server 2017. I am trying to use the in operator,...

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers