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: )

5,313 reads

Blogs

SQL Training: Black Friday Deals Up to 75% Off

By

This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...

When is the perfect moment to build a data strategy in a company?

By

The post When is the perfect moment to build a data strategy in a...

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Read the latest Blogs

Forums

Have Grace

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Have Grace

The Hash Join II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Hash Join II

Simplify Data Loading with Fivetran (HVR): Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Simplify Data Loading with Fivetran...

Visit the forum

Question of the Day

The Hash Join II

Which of these inputs is the smaller input to a hash join?

See possible answers