PagerSendSubjectOnly 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 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.