November 19, 2008 at 11:10 am
I am new to SQL replication… Finally, was able to configure a snapshot replication and it works great, but I can not figure out how to schedule it…
This is what I am doing to start it manually:
1.(On source server); Right-click the publication and choose re-initialize all subscriptions choose “Use a new snapshot” “Generate a new snapshot immediately” “Mark for Reinitialization”..
2.(On subscriber server (other then the source) right-click on subscription choose “View Synchronization status” - “Start”
Is there a way to schedule it all with GUI? If not, please point me to a good source/tutorial on how to do it…
Thanks in advance!
November 19, 2008 at 10:16 pm
I have not tested it, but I believe you can schedule the snapshot by scheduling the snapshot agent job (which has a category of "REPL-Snapshot") on the distributor server.
November 20, 2008 at 8:17 am
All replication agents should have a scheduled job that you can change. Do the following:
1) Run Replication Monitor
2) Navigate to your snapshot publication and highlight it
3) Select the "Agents" tab
4) Right click on the Snapshot Agent job and choose "Properties" to open the job properties window
5) Select "schedules" on the list on the left and modify your schedule as necessary
November 20, 2008 at 4:41 pm
I am sorry, I am off-site today - will test it tomorrow morning... Please check if you could with this post in case I have more questions... In any event, thank you very much!!!!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply