Creates or updates a user-defined execution class that you can bind to client applications, logins, and stored procedures.
sp_addexeclass classname, priority, timeslice, engine_group
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.
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"
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.
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.
Only a System Administrator can execute sp_addexeclass.
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
