Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Alert.NotificationMessage Property

Gets or sets the user-supplied text appended to any notification sent in response to an alert being raised.

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Matrix)]
public string NotificationMessage { get; set; }

Property Value

Type: String
A String value that specifies the user-supplied text appended to the any notification.

When a Microsoft SQL Server alert is raised, SQL Server Agent builds a message and sends notifications as a response. The notification message is built with default parts and user-controlled parameters. To add user-specified text to an alert, set the NotificationMessage property of an Alert object.

Community Additions

Show:
© 2015 Microsoft