Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

force the replication agent

Posted on 2006-06-29
2
Medium Priority
?
501 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:gumball_ch
  • 2
2 Comments
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 17009667
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
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 500 total points
ID: 17009674
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question