Clears the execution attributes of an Adaptive Server session that was set by sp_setpsexe.
sp_clearpsexe spid, exeattr
is the process ID of the session for which execution attributes are to be cleared.
identifies the execution attributes to be cleared. Values for exeattr are “priority” and “enginegroup”.
sp_clearpsexe 12, 'enginegroup'
Drops the engine group entry for process 12.
sp_clearpsexe clears the execution attributes of the session that was set by sp_setpsexe. For more information, see the Performance and Tuning Guide.
If the execution attributes are not cleared during the lifetime of the session, they are cleared when the session exits or terminates abnormally.
sp_clearpsexe fails if there are no online engines in the associated engine group.
When you drop an engine group entry, the session executes on an engine group determined by a class definition or by the default class.
Use sp_who to list process IDs (spids).
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.
System procedures sp_addexeclass, sp_bindexeclass, sp_dropexeclass, sp_showexeclass, sp_unbindexeclass
