Share via

PagerSendSubjectOnly Property

  • Article

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 PagerSendSubjectOnly property controls message text sent when SQL Server Agent attempts to notify an operator by pager.

Syntax

object
.PagerSendSubjectOnly [= value]

Parts

  • object
    An 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.

Applies To:

AlertSystem Object