force the replication agent

hi there

I have a replication-publication on a SQL 2000 Server and 5 subscribers (push). The scheduler starts the merge agent every 15min.
Now I have a procedure, which is very urgent that this change is replicate imediatly.
How can I start all agents to push that change imediatly?

Thanks

gumball_ch
gumball_chAsked:
Who is Participating?
 
Kevin3NFCommented:
Or, you can create a stored proc that uses sp_startjob to start all 5 merge agent jobs one right after the other, then just exec the sp
0
 
Kevin3NFCommented:
Right-click the agent, Click Start Agent....each one has to be done individually, but you should be able to do them all one after the other
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.