We have AGs set up (1 primary and 2 secondaries (Includes DR)).
We have an archival job set up in each replica with same schedule and enabled in all three replicas.
This job runs in a frequency of about 15 minutes each day.
My question is:
Since the job in each replica is pointed to primary server while running :
Can I let the job run only in Primary Replica and disable the Job in secondary replicas ? Will it affect otherwise ?
In AlwaysOn AGs will the jobs also be failed over ?
If jobs not failover
My thinking is once the primary is failed over to other node (which is would be primary or current secondary synchronized) and since the secondary replica is now primary and the job will be in disabled state (If at all we can disable the jobs in secondary ?), I just need to enable it on the current replica.
Kindly correct my thinking ?