PagerSendSubjectOnly Property

SQL-DMO

SQL-DMO

PagerSendSubjectOnly Property

The PagerSendSubjectOnly property controls message text sent when Microsoft® SQL Server™ 2000 Agent attempts to notify an operator by page.

Applies To
AlertSystem Object
Syntax

object.PagerSendSubjectOnly [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetPagerSendSubjectOnly(LPBOOL pRetVal);

HRESULT SetPagerSendSubjectOnly(BOOL NewValue);

Remarks

If TRUE, only the subject line is filled in on e-mail sent by SQL Server Agent for pager notifications.

If FALSE, the e-mail subject line and message text fields are used to construct notification messages sent by SQL Server Agent. The default is FALSE.

E-mail message body text varies in complexity depending on the cause (raised alert or job completion) of the notification.