EventlogLevel Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The EventlogLevel property specifies the job completion status that causes an operating system log entry on job completion.
Syntax
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);
Remarks
Set the EventlogLevel property to enable operating system log entries for the job.