NetSendLevel Property (SQL-DMO)

The NetSendLevel property controls SQL Server Agent operator network popup message notification on job completion.

object.NetSendLevel [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Long integer specifying job completion status as described in Settings

Constant	Value	Description
SQLDMOComp_All	6	Send network popup message to operator regardless of success or failure.
SQLDMOComp_Always	3	Send network popup message to operator regardless of success or failure.
SQLDMOComp_Failure	2	Send network popup message to operator when job fails to complete successfully.
SQLDMOComp_None	0	Ignore any completion status. Do not send network popup message to operator.
SQLDMOComp_Success	1	Send network popup message to operator on successful completion.
SQLDMOComp_Unknown	4096	Invalid value.

SQL Server Agent can send notification of job completion using e-mail, network popup message, or pager.

To enable a job for network popup 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 popup message notification based on job completion.

Long, enumerated

Read/write

HRESULT GetNetSendLevel(SQLDMO_COMPLETION_TYPE* pRetVal);

HRESULT SetNetSendLevel(SQLDMO_COMPLETION_TYPE NewValue);