Alert.JobName Property

Gets or sets the name of the SQL Server Agent job that is run in response to the alert being raised.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property JobName As String 
    Get
'Usage
Dim instance As Alert 
Dim value As String 

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

Property Value

Type: System.String
A String value that specifies the name of the job that is run in response to the raised alert.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

Alert Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_add_alert (Transact-SQL)