Creates or updates a user-defined execution class that you can bind to client applications, logins, and stored procedures.
The predefined engine group parameter ANYENGINE and LASTONLINE are valid only in process mode.
sp_addexeclass classname, priority, timeslice, engine_group [, instance_id]
is the name of the new execution class.
is the priority value with which to run the client application, login, or stored procedure after it is associated with this execution class. Legal values are HIGH, LOW, and MEDIUM.
is the time unit assigned to processes associated with this class. Adaptive Server currently ignores this parameter.
identifies an existing group of engines on which processes associated with this class can run.
(in cluster environments) ID of the instance to which you are binding a user-defined execution class.
Defines a new execution class called DS with a priority value of LOW and associates it with the engine group DS_GROUP:
sp_addexeclass "DS", "LOW", 0, "DS_GROUP"
In cluster environments – Defines a new execution class called DS with a priority value of LOW and associates it with the engine group DS_GROUP on instance number 8, enter:
sp_addexeclass "DS", "LOW", 0, "DS_GROUP", 8
sp_addexeclass creates or updates a user-defined execution class that you can bind to client applications, logins, and stored procedures. If the class already exists, the class attribute values are updated with the values supplied by the user.
When you run sp_addexeclass in threaded mode, Adaptive Server uses engine_group for the name of a thread pool.
(In cluster environments) 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.
Use the predefined engine group parameter ANYENGINE if you do not want to restrict the execution object to an engine group.
Use sp_addengine to define engine groups. Use sp_showexeclass to display execution class attributes and the engines in any engine group associated with the specified execution class. sp_showcontrolinfo lists the existing engine groups.
The permission checks for sp_addexeclass differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage any execution class privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. |
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_addengine, sp_bindexeclass, sp_clearpsexe, sp_dropengine, sp_dropexeclass, sp_setpsexe, sp_showcontrolinfo, sp_showexeclass, sp_showpsexe, sp_unbindexeclass
