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