I have two servers (Primary and Secondary), as well as an AG that keeps them in sync.
As we all know, System databases are not covered by the AG definition.
1.I require that all jobs on the primary server be in sync with those on the secondary server.
2.However, I just want the job to run on the primary, not the secondary. Is there anything I can do? Any sql code ? Kindly explain I am new to DBA.