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 that of the Microsoft® SQL Server™ installation
| Constant | Value | Description |
|---|---|---|
| SQLDMORunPri_AboveNormal | 1 | Slightly elevated priority |
| SQLDMORunPri_BelowNormal | -1 | Reduced priority |
| SQLDMORunPri_Highest | 2 | Highest priority level allowed by the process priority |
| SQLDMORunPri_Idle | -15 | No CPU time will be spent on this thread unless all other threads are blocked |
| SQLDMORunPri_Lowest | -2 | Least, scheduled priority allowed by the process priority |
| SQLDMORunPri_Min | 1 | SQLDMORunPri_ AboveNormal |
| SQLDMORunPri_Normal | 0 | Standard priority level for the given process priority |
| SQLDMORunPri_TimeCritical | 15 | No CPU time will be given other processes while the job step executes |
| SQLDMORunPri_Unknown | 100 | Value is invalid |