This topic has not yet been rated - Rate this topic

Alert.CategoryName Property

SQL Server 2008

Gets or sets the name of the category to which the alert belongs.

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

Syntax

C++

JScript

[SfcPropertyAttribute]
public string CategoryName { get; set; }

Property Value

Type: System.String
A String value that specifies the name of the alert category.

Remarks

The CategoryName property of the Microsoft SQL Server Management Objects (SMO) Alert object references an applicable SQL Server Agent category.

Setting the Category property for the JobFilter object restricts listed SQL Server Agent jobs to those having the category when using the EnumJobs method of the JobServer object.

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