OSRunPriority Property
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The OSRunPriority property controls execution thread scheduling for job steps executing operating system tasks.
Syntax
object.OSRunPriority [=value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer that specifies an operating system task execution priority level as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetOSRunPriority(
SQLDMO_RUNPRIORITY_TYPE* pRetVal);
HRESULT SetOSRunPriority(
SQLDMO_RUNPRIORITY_TYPE NewValue);
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 is spent on this thread unless all other threads are blocked. |
SQLDMORunPri_Lowest |
-2 |
Lowest priority level allowed by the process priority. |
SQLDMORunPri_Normal |
0 |
Standard priority level. |
SQLDMORunPri_TimeCritical |
15 |
No CPU time is given to other processes while the job step executes. |
SQLDMORunPri_Unknown |
100 |
The value is not valid. |
Hinweise
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.
.gif "Vorsichtshinweis") Vorsicht |
|---|
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. |