Hi
I've created a snapshot replication to copy a couple of tables from one database to another in the same server. I scheduled to run it at 2:00 am daily. The problem is that the job doesn't run as scheduled. If I click "start synchronizing", it runs and the tables are replicated. Currently all the agents related to this replication are in the "stop" status (red dot). I don't know whether they should be stay like this or not. I tried to start them, but they never turn to the "green triangle" (symbol of start). How can I make it run as scheduled?
Thanks in advance...
jz
I've created a snapshot replication to copy a couple of tables from one database to another in the same server. I scheduled to run it at 2:00 am daily. The problem is that the job doesn't run as scheduled. If I click "start synchronizing", it runs and the tables are replicated. Currently all the agents related to this replication are in the "stop" status (red dot). I don't know whether they should be stay like this or not. I tried to start them, but they never turn to the "green triangle" (symbol of start). How can I make it run as scheduled?
Thanks in advance...
jz