sp_addexeclass includes the instance_id parameter which allows you to create or update a user-defined execution class and bind it to a specific instance. The syntax is:
sp_addexeclass class_name, priority, timeslice, engine_group [, instance_id]]
where instance_id is the id of the instance to which you are binding a user-defined execution class. For example, to define a new execution class called DS with a priority value of LOW and associate it with the engine group DS_GROUP on instance number 8, enter:
sp_addexeclass "DS", "LOW", 0, "DS_GROUP", 8
If sp_cluster set system_view is set to cluster, you can add an execution class on any instance in the cluster. If the system_view is set to instance, you can add an execution class only to a local instance.
