I have an archival job in my SQL Server which is part of AOAG. I can see the same job in all replicas which are part of AOAG and it's scheduled at the same time.
It is running at the same time on all servers for around 30 seconds successfully.
Can anyone let me know the logic behind the same job same schedule in all replicas successfully running.
It is connecting through AOAG listener to servers and the first step will be copying a file to another location and running the archival job, on job success the source location will be deleted. This is what I can see in job properties-->steps.
I need to create a new customized archival job.
What will be the problem if I create the job with 5 minutes difference in each replica?
Will there be any problem if I schedule this job at same time in each replica?