sp_clearpsexe

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

Drops the engine group entry for process 12.

sp_clearpsexe 12, 'enginegroup'

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.

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

Granular permissions 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.

Granular permissions 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:

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