共用方式為


Alert.NotificationMessage 屬性

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

命名空間:  Microsoft.SqlServer.Management.Smo.Agent
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property NotificationMessage As String 
    Get 
    Set
'用途
Dim instance As Alert 
Dim value As String 

value = instance.NotificationMessage

instance.NotificationMessage = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public string NotificationMessage { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property String^ NotificationMessage {
    String^ get ();
    void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member NotificationMessage : string with get, set
function get NotificationMessage () : String 
function set NotificationMessage (value : String)

屬性值

型別:System.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.

範例

使用 SQL Server Agent 排程自動管理工作

請參閱

參考

Alert 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)

sp_add_alert (Transact-SQL)