PageLevel Property (SQL-DMO)

The PageLevel property controls SQL Server Agent operator page notification on job completion.

object.PageLevel [= value]

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

Constant	Value	Description
SQLDMOComp_All	6	Page operator regardless of success or failure.
SQLDMOComp_Always	3	Page operator regardless of success or failure.
SQLDMOComp_Failure	2	Page operator when job fails to complete successfully.
SQLDMOComp_None	0	Ignore any completion status. Do not page operator.
SQLDMOComp_Success	1	Page 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 pager notification

Set the OperatorToPage property to the name of an existing SQL Server Agent operator.
Set the PageLevel property to control Microsoft® SQL Server™ network popup message notification based on job completion.

Long, enumerated

Read/write

HRESULT GetPageLevel(SQLDMO_COMPLETION_TYPE* pRetVal);

HRESULT SetPageLevel(SQLDMO_COMPLETION_TYPE NewValue);