Groups | Blog | Home
all groups > sql server replication > december 2006 >

sql server replication : Run a Snapshot agent from a script or cmdline


scooper NO[at]SPAM kustomsignals.com
12/13/2006 7:15:49 AM
I would like to be able to run a snapshot agent from a TSQL script or
from a cmd line. I have merge replication setup to several different
publications and would like to script all of the snapshot agents to run
on cmd rather on a schedule. I am using SQL Server 2000 with SP3.


Thank You in advance.
Paul Ibison
12/13/2006 4:11:26 PM
You could use sp_start_job from TSQL, or use the activeX control if you want
the command-line control.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

AddThis Social Bookmark Button