I am just learning about replication, as I have been asked to set up a merge replication for one of our databases. Besides being completely overwhelmed by the whole thing
I do have a question that I cannot seem to find an answer for.
The database I plan to set up replication for has several SQL Agent jobs that add/update/maintain the data within the tables. How are Agent jobs handled with merge replication? Are jobs on both the publisher and the subscriber, or do they run only on the publisher and then the data is updated when synchronization occurs?
As a side note - I have learned lots from the Stairway to Replication by Sebastian Meine. Excellent reading – and for a newbie like me, written in language I can understand. Kudos to Sebastian!