sp_addexeclass

Description

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

Syntax

sp_addexeclass classname, priority, timeslice, engine_group

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.

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"

Usage

Permissions

Only a System Administrator can execute sp_addexeclass.

See also

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