sp_clearpsexe

Description

Clears the execution attributes of an Adaptive Server session that was set by sp_setpsexe.

Syntax

sp_clearpsexe spid, exeattr

Parameters

spid

is the process ID of the session for which execution attributes are to be cleared.

exeattr

identifies the execution attributes to be cleared. Values for exeattr are “priority” and “enginegroup”.

Examples

Example 1

Drops the engine group entry for process 12.

sp_clearpsexe 12, 'enginegroup'

Usage

Permissions

Only a System Administrator can execute sp_clearpsexe to clear priority attributes for all users. Any user can execute sp_clearpsexe to clear the priority attributes of tasks owned by that user.

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

Documents sp_clearpsexe clears the execution attributes of the session that was set by sp_setpsexe. For more information, see the Performance and Tuning Guide.

System procedures sp_addexeclass, sp_bindexeclass, sp_dropexeclass, sp_showexeclass, sp_unbindexeclass