For example, to turn off error log searches for an entire server, insert a row into dbo.CollectionExceptionsServer for that particular instance, using the collection table name (“Collector.ErrorLog”) as the CollectionName:
INSERT INTO dbo.CollectionExceptionsServer ( InstanceID, CollectionName ) VALUES ( 11 , 'Collector.ErrorLog' );
Let's take another example: If Svr1 is a Gold level server, but you don’t want any job scripts generated for it, insert a row to dbo.CollectionExceptionsServer (using the InstanceID for Svr1 from dbo.Servers:
INSERT INTO dbo.CollectionExceptionsServer ( InstanceID, CollectionName ) VALUES ( 99 , 'JobScript' );
Now, InstanceID 99 (Svr1) will no longer take part in the Script Jobs collection!
https://minionware.desk.com/customer/portal/articles/2853590-how-to-stop-a-collection-for-one-server
http://MinionWare.net