Technical Article

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.

5 (1)

You rated this post out of 5. Change rating

2018-11-14 (first published: )

4,445 reads

Blogs

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

By

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...

Read the latest Blogs

Forums

kopen valse paspoort (Telegram:+31637257997), rijbewijs,

By asuar1456

kopen valse paspoort (Telegram:+31637257997), rijbewijs, id kaart VISA, GROENE KAART, DIPLOMA'S Wij zijn de...

Comprar pasaporte falso (Telegrama:+34691183638)

By asuar1456

Somos los mejores productores de documentos de calidad , con más de 12 millones...

Comprar pasaporte falso (Telegrama:+34691183638), licencia de

By asuar1456

Comprar dni falso (Telegrama:+34691183638), licencia de conducir, pasaporte VISAS, TARJETA VERDE, DIPLOMAS Comprar dni...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers