Replication agents are idles
in [Replication]
|
Prev: New article - snapshot not applying at subscriber
Next: Indexed Views - Clustered Index is NOT replicated (not scripted by
From: wadii boulila on 1 Mar 2010 13:44 I have performed a transactional replication in my company. This done through a script SQL that I wrote. Everything is OK. However, replication agents are still idles. I need a script or a command sql to start the three agents (snapshot, journal and distribution). When I right click and I set start they work. However, I need to perform this automatically with a script transact-sql or a command sql. url:http://www.ureader.com/gp/1156-1.aspx
From: Paul Ibison on 3 Mar 2010 15:12
Sp_start_job is all you need. HTH, Paul Ibison |