Control SQL Jobs based on HADR Role – Taking it to the Next Level
In one of my previous blog posts, Automatically Enable or Disable Jobs based on HADR Role, I provided a solution for automatically enabling or disabling scheduled jobs in combination with Availability Groups and Database Mirroring. In this blog post, I’m going to build upon my previous solution and improve it even further – taking it to the next level of automation!
Read More »Control SQL Jobs based on HADR Role – Taking it to the Next Level