SQL Server Performance Forum – Threads Archive
Disabling merge replication agents
Hi 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,LesleyG
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
Nathan H.O.
Moderator
SQL-Server-Performance.com
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.
Moderator
SQL-Server-Performance.com
]]>