snapshot agent schedule in a transactional replication

Question

hello, we have newly setup a transaction replication. I see our snapshot agent job runs every hour. If i want to disable this setting of generating snapshot every hour should i just disable the schedule or is there any other setting for this?

Also when snapshot agent runs every hour does it create new snapshot each time or it only creates snapshot with new changes that have been done since the last snapshot (incremental way). Thank you

Answer 1

Hi @Heisenberg ,

As Tom mentioned that snapshot agent is only used for first time initialization and if new articles are added and need initialization. So this job does not need to be scheduled to run every hour. You can change this follow below steps.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Snapshot agent is only used for first time initialization and if new articles are added and need initialization. It does not do anything if there is not new articles added.

Answer 3

i agree, but i see the snapshot agent job is scheduled to run every hour in my environment why would it be and how can i change it?

Answer 4

Thank you @CathyJi-MSFT