SQL Server Performance Forum – Threads Archive
Disabling merge replication agentsHi folks, I have a large number of merge replication agents that I need to disable. Rather than using Enterprise Mananger to disable each one in turn, can anyone suggest a quicker method of doing this? thanks,
If you are ready for some programming, you can try out the SQLDMO Jobs collection or jump straight into the SQL Merge Control Dim oJob as Job For each oJob in YourServer.Jobs
‘// if this job meets some particular criteria
‘//Insert logic here for checking if this job should be disabled oJob.Stop Next
This link http://www.winnetmag.com/SQLServer/Articles/ArticleID/39079/pg/2/2.html] may also set you going if you are trully interested. Nathan H.O.