Note: this is not duplicate question.
I have setup AlwaysOn. I have created SQL agent jobs manually on both the nodes. right now all the active jobs are running if node is PRIMARY.
My DBA will disable few SQL agent jobs manually in only one node based on business requirements. Now how does it synchronizes to node 2? Will DBA have to manually disable these related jobs in all the secondary nodes ?
I am thinking of creating a table (this table will be part of availability group) where I maintain the state of the jobs. and during fail over I am planning to run the script to read the data from this table and set the state of the jobs on other nodes. Is it right way? or do we have any recommended steps?