This topic has not yet been rated - Rate this topic

Alert.IncludeEventDescription Property

SQL Server 2008 R2

Gets or sets the NotifyMethods object value that specifies the types of notification methods (e-mail, pager, or net send) that can contain alert error text.

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

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public NotifyMethods IncludeEventDescription { get; set; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.Agent.NotifyMethods
A NotifyMethods object value that specifies the notification methods used by the alert.

Remarks

SQL Server Agent builds a notification message to send in response to a raised alert. For each notification method (e-mail, pager, or net send), SQL Server Agent can build a different message. To include alert error text in a SQL Server Agent-built message, set the IncludeEventDescription property of the referring Alert object.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

Reference

Alert Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automating Administrative Tasks (SQL Server Agent)

sp_add_alert (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD