This topic has not yet been rated - Rate this topic

Alert.IsEnabled Property

SQL Server 2008

Gets or sets the Boolean property value that specifies whether the alert is enabled or not.

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

Syntax

C++

JScript

[SfcPropertyAttribute]
public bool IsEnabled { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether the alert is enabled or not.
If True, the alert is enabled and is raised when the specified event or performance condition occurs.
If False (default), the alert is disabled and does not respond to any events or performance conditions.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

Reference

Alert Class

Alert Members

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