The OSRunPriority property controls execution thread scheduling for job steps executing operating system tasks.
object.OSRunPriority [= value]
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies an operating system task execution priority level as described in Settings
Long, enumerated
Read/write
HRESULT GetOSRunPriority(
SQLDMO_RUNPRIORITY_TYPE* pRetVal);
HRESULT SetOSRunPriority(
SQLDMO_RUNPRIORITY_TYPE NewValue);
| 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 level allowed by the process priority. |
| SQLDMORunPri_Min | 1 | SQLDMORunPri_AboveNormal. |
| SQLDMORunPri_Normal | 0 | Standard priority level. |
| SQLDMORunPri_TimeCritical | 15 | No CPU time will be given other processes while the job step executes. |
| SQLDMORunPri_Unknown | 100 | Value is invalid. |
Set the OSRunPriority property to alter execution thread scheduling for job steps executing operating system commands. The property specifies a thread priority relative to that granted to an instance of Microsoft® SQL Server™ 2000.
Caution Setting operating system thread priority can have adverse effects on other processes running on the server. Care should be taken when specifying priorities above normal (SQLDMORunPri_Min).