The OSRunPriority property controls execution thread scheduling for job steps executing operating system tasks.
object.OSRunPriority [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying an operating system task execution priority level as described in Settings |
| 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 the Microsoft® SQL Server™ installation.
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).
Long, enumerated
Read/write
HRESULT GetOSRunPriority(
SQLDMO_RUNPRIORITY_TYPE* pRetVal);
HRESULT SetOSRunPriority(
SQLDMO_RUNPRIORITY_TYPE NewValue);