muthyala_51 (8/4/2014)
Can we stop and start sql server agent based on AG failover ? Instead of editing all the jobs/job steps to check which one is primary before running, it sounds like a good idea if we can stop and start the agents accordingly. Any suggestions?
Not really going to work as stopping the agent will affect the whole instance. The instance that is a secondary replica may have other databases on it that are not part of the AlwaysOn group and still require a functioning agent.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉