NetSendLevel Property
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The NetSendLevel property controls SQL Server Agent operator network message notification on job completion.
Sintassi
object
.NetSendLevel [= value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
A 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 |
Sends a network message to the operator regardless of success or failure. |
SQLDMOComp_Always |
3 |
Sends a network message to the operator regardless of success or failure. |
SQLDMOComp_Failure |
2 |
Sends a network message to the operator when job fails to complete successfully. |
SQLDMOComp_None |
0 |
Ignores any completion status. It does not send a network message to the operator. |
SQLDMOComp_Success |
1 |
Sends a network message to the operator on successful completion. |
SQLDMOComp_Unknown |
4096 |
The value is not valid. |
Osservazioni
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.