sp_addengine  sp_addextendedproc

Chapter 1: System Procedures

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.

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





Copyright © 2005. Sybase Inc. All rights reserved. sp_addextendedproc

View this book as PDF