SQL-DMO
Job Step OS Priority Constants (SQLDMO_RUNPRIORITY_TYPE)
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 | 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. |