I am new to AOAGs and Can Anyone please help me get out of below confusion.
I have 3 Replica AOAG. I have a Archival Job in 3 Replicas scheduled at same time which will run every 15 minutes.
- AlwaysOn Job logically will always look for the Primary replica.Is it correct ?
- If the same job exists in all the AOAG replicas(Primaries and Secondaries) and scheduled at same time and why it is succeeding still with any failure ?Same job it runs in Primary and secondary without any conflict?can you please help me understanding this logic ?
- Which do you recommend ,scheduling the job at same time or with a difference of time around 5 minutes in secondaries.
- Can you hint me on what if same time and what if different time scheduled?
- Same Job if it runs in Primary will it run even in secondaries also as they are scheduled at same time ?