I need to automate the starting of the snapshot agent. At the moment i have to go into replication monitor right click on snapshot agent and click start.
Is this possible in T-SQL or do you have to use the DOS cmd. Any sample code would be nice,
Every time the you create a publication a jobs is created in sql server with this name
don't you have it on you job list ?
there is an step inside the job that look like this
-Publisher [SQL05] -PublisherDB [db_1] -Distributor [SQL05] -Publication [publ_db_1] -ReplicationType 2 -DistributorSecurityMode 1