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!