EventlogLevel Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The EventlogLevel property specifies the job completion status that causes an operating system log entry on job completion.

Sintaxis

object
.EventlogLevel [=value]

Parts

• object
  An expression that evaluates to an object in the Applies To list.

• value
  Specifies a job completion status as described in Settings.

Settings

Value	Description
SQLDMOComp_All	SQLDMOComp_Always.
SQLDMOComp_Always	Logs regardless of success or failure.
SQLDMOComp_Failure	Logs failed job completion.
SQLDMOComp_None	Ignores any completion status. It does not log completion.
SQLDMOComp_Success	Logs successful job completion.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetEventlogLevel(SQLDMO_COMPLETION_TYPE* pRetVal);
HRESULT SetEventlogLevel(SQLDMO_COMPLETION_TYPE NewValue);

Notas

Set the EventlogLevel property to enable operating system log entries for the job.

Applies To:

Job Object