SQL Server Replication - only ran once. How to configure scheduler from beginning
0
votes
1
answer
145
views
I have configured a transactional replication from server A to Server B some 2 month ago.
The source database is a new production server, and the data is being updated there constantly.
I have some issues ... I am not sure how to resolve.
1. I see that the "last sync" occurred 2 month ago, when I initially set it up.
- I was expecting a snapshot job to be of a periodic nature, but it is not.
- It is actually set to a "One time" and is not enabled. I know, I can "enable it" and
set the schedule for the future, however I am looking for how to do it at the time when I configure the replication. I may be configuring it with the script and be expecing the configuration go into effect from the power shell script rn, and want to make sure i know how to set the schedule from the beginning.
This is what I see in a schedule of a Snapshot job on the Sql Server agent.

Asked by Dmitriy Ryabin
(111 rep)
May 21, 2024, 01:55 PM
Last activity: Jul 20, 2025, 06:03 AM
Last activity: Jul 20, 2025, 06:03 AM