sp_addexeclass

Considerations for process mode

The predefined engine group parameter ANYENGINE and LASTONLINE are valid only in process mode.

sp_addexeclass classname, priority, timeslice, engine_group [, instance_id]

classname – is the name of the new execution class.
priority – 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.
timeslice – is the time unit assigned to processes associated with this class. The SAP ASE server currently ignores this parameter.
engine_group – identifies an existing group of engines on which processes associated with this class can run.
instance_id – (in cluster environments) ID of the instance to which you are binding a user-defined execution class.

Example 1 – 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"
```
Example 2 – (Cluster Edition) 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
```

There are additional considerations when using sp_addexeclass:

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, the SAP ASE 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.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage any execution class` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role.

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect