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.

(1)

You rated this post out of 5. Change rating

2018-11-14 (first published: )

5,986 reads

Blogs

PlanTrace Now Supports PostgreSQL

By

PlanTrace Now Supports PostgreSQL The same plan analysis you know from...

A New Word: the Kinder Surprise

By

the kinder surprise – . the point in your early adolescence when you realize...

Crash-Consistent Snapshot Cloning - Hyper-V Edition

By

If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...

Read the latest Blogs

Forums

BCA KCU MENARA BIDAKARA CSTelpon : 0853-73737551

By vuakietac

CSTelpon : 0853-73737551 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...

BCA KCP Wisma Mulia CSTelpon : 0853-73737551

By vuakietac

Jl. Gatot Subroto No.42 Suite G02, Kuningan Bar., Kec. Mampang Prpt., Kota Jakarta Selatan,...

BCA KCP Hasanudin CSTelpon : 0853-73737551

By vuakietac

Jl. Sultan Hasanuddin Dalam No.43/48, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus...

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers