We are running AlwaysOn on three replicas. The primary and first secondary are synchronous for failover purposes. The second secondary is a read-only asynchronous server for reporting. The only thing we don't have a good handle on is SQL Agent jobs on failover. I've seen a few solutions from others, but nothing I thought was really slick. How do you handle SQL Agent jobs on a secondary replica that is intended for failover?
Asked
Active
Viewed 68 times
