<div>
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
</div>


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

<div>
<div class="content wysiwyg-content">
hi there<br />
<br />
I have a replication-publication on a SQL 2000 Server and 5 subscribers (push). The scheduler starts the merge agent every 15min.<br />
Now I have a procedure, which is very urgent that this change is replicate imediatly. <br />
How can I start all agents to push that change imediatly?<br />
<br />
Thanks<br />
<br />
gumball_ch
</div>
</div>


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

force the replication agent

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.