sp_clearpsexe

Syntax

sp_clearpsexe spid, exeattr

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

Example 1 – Drops the engine group entry for process 12.
```
sp_clearpsexe 12, 'enginegroup'
```

There are additional considerations when using sp_clearpsexe:

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

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

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage any execution class` privilege. Any user can execute sp_clearpsexe to clear the priority attributes of tasks owned by that user.
Disabled	With granular permissions disabled, you must be a user with sa_role. Any user can execute sp_clearpsexe to clear the priority attributes of tasks owned by that user.

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

Information	Values
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