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

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.

2018-11-14 (first published: )

992 reads

Blogs

Daily Coping 9 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Webinar: How to unlock the value of frequent deployments

By

I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...

SSMS 18.5 Fixes from Redgate

By

I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...

Read the latest Blogs

Forums

Do You Have a Mentor?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Have a Mentor?

Counting Rows in DAX

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Rows in DAX

Select return no records

By gjoelson 29755

Hello, I feel stupid asking this...I should be able to work itout, but here...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers