eitanblumin.com
How to HADR Your SQL Jobs - Eitan Blumin's blog
You have a couple or more SQL Servers with some sort of High Availability solution between them (AlwaysOn / Mirroring). You also have scheduled jobs that need to be run on the PRIMARY. But how would you make that work when a failover happens? There are a few ways to solve this. In this session, we will cover possible solutions, downfalls, tricks, and much more.