SQL-DMO
NetSendLevel Property
The NetSendLevel property controls Microsoft® SQL Server™ 2000 Agent operator network message notification on job completion.
Applies To
| Job Object |
Syntax
object.NetSendLevel [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies job completion status as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetNetSendLevel(SQLDMO_COMPLETION_TYPE* pRetVal);
HRESULT SetNetSendLevel(SQLDMO_COMPLETION_TYPE NewValue);
Settings
| Constant | Value | Description |
|---|---|---|
| SQLDMOComp_All | 6 | Send network message to operator regardless of success or failure. |
| SQLDMOComp_Always | 3 | Send network message to operator regardless of success or failure. |
| SQLDMOComp_Failure | 2 | Send network message to operator when job fails to complete successfully. |
| SQLDMOComp_None | 0 | Ignore any completion status. Do not send network message to operator. |
| SQLDMOComp_Success | 1 | Send network message to operator on successful completion. |
| SQLDMOComp_Unknown | 4096 | Invalid value. |
Remarks
SQL Server Agent can send notification of job completion using e-mail, network message, or pager.
To enable a job for network pop-up message notification
- Set the OperatorToNetSend property to the name of an existing SQL Server Agent operator.
- Set the NetSendLevel property to control SQL Server Agent network message notification based on job completion.