OSRunPriority Property

Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa caratteristica in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

The OSRunPriority property controls execution thread scheduling for job steps executing operating system tasks.

Sintassi

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.

Osservazioni

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.

Attenzione
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.

Applies To:

JobStep Object