Job Step OS Priority Constants (SQLDMO_RUNPRIORITY_TYPE)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Operating system execution priority constants specify a relative base priority assigned to the execution thread of job steps specifying operating system commands.

The constants specify a thread priority relative to an instance of Microsoft SQL Server.

Constant	Value	Description
SQLDMORunPri_AboveNormal	1	This thread has slightly elevated priority.
SQLDMORunPri_BelowNormal	-1	This thread has reduced priority.
SQLDMORunPri_Highest	2	This thread has the highest priority level allowed by the process priority.
SQLDMORunPri_Idle	-15	CPU time is spent on this thread only if all other threads are blocked.
SQLDMORunPri_Lowest	-2	This thread has the least scheduled priority allowed by the process priority.
SQLDMORunPri_Min	1	SQLDMORunPri_AboveNormal.
SQLDMORunPri_Normal	0	This thread has the standard priority level for the given process priority.
SQLDMORunPri_TimeCritical	15	CPU time is given to other processes while the job step executes.
SQLDMORunPri_Unknown	100	The value is not valid.