SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Eitan Blumin

SQLServerCentral.com profile

   Items 1 to 1 of 1   
 

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.  Read more...
By Eitan Blumin 2018/11/14 | Source: SQLServerCentral.com | Category: always on
Rating: (not yet rated) |  Discuss |   Briefcase | 198 reads
   Items 1 to 1 of 1