NetSendLevel 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 NetSendLevel property controls SQL Server Agent operator network message notification on job completion.

object.NetSendLevel [= value]

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

Long, enumerated

Read/write

HRESULT GetNetSendLevel(SQLDMO_COMPLETION_TYPE* pRetVal);
HRESULT SetNetSendLevel(SQLDMO_COMPLETION_TYPE NewValue);

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.

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

  1. Set the OperatorToNetSend property to the name of an existing SQL Server Agent operator.

  2. Set the NetSendLevel property to control SQL Server Agent network message notification based on job completion.

Community Additions

ADD
Show: