March 20, 2005 at 7:55 pm
I am having trouble with my snapshot replication in sql server 2000. I want it to replicate twice a day and it tries to do so but says that there were no records to update. Since I know there was I assume that the problem is that my snapshot agent is not running. How can I schedule that as well?
Thanks!
March 22, 2005 at 4:21 am
Hi,
Is your distribution agent scheduled to run?
Graeme
March 22, 2005 at 4:22 am
I am not sure-where do I schedule that?
March 22, 2005 at 4:32 am
Go to the Replcation Monitor and expand the agents node.
Click on the Distribution Agent folder.
In the left hand window you should see a list of your agents.
Right click on the one you want and select Agent Properties. This will open the job that runs this agent. You can check to see if this has a schedule.
This probably does not want to be too frequent...if it does then perhaps you are using the wrong type of replication.
Regards..Graeme
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply