sp_dropexeclass

Drops a user-defined execution class.

Syntax

sp_dropexeclass classname

Parameters

Examples

Usage

An execution class helps define the execution precedence used by the SAP ASE server to process tasks. See the Performance and Tuning Guide for more information on execution classes and execution attributes.

classname must not be bound to any client application, login, stored procedure, or default execution class. Unbind the execution class first, using sp_unbindexeclass, then drop the execution class, using sp_dropexeclass.

You cannot drop system-defined execution classes.

Permissions

The permission checks for sp_dropexeclass differ based on your granular permissions settings.

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

Auditing

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

InformationValues
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

Related reference
sp_addexeclass
sp_bindexeclass
sp_showexeclass
sp_unbindexeclass