sp_addexeclass

Description

Creates or updates a user-defined execution class that you can bind to client applications, logins, and stored procedures.

Considerations for process mode

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

Syntax

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

Parameters

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. Adaptive 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.

Examples

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

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

Usage

Permissions

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.

Auditing

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

  • 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

See also

System procedures sp_addengine, sp_bindexeclass, sp_clearpsexe, sp_dropengine, sp_dropexeclass, sp_setpsexe, sp_showcontrolinfo, sp_showexeclass, sp_showpsexe, sp_unbindexeclass