Aracılığıyla paylaş


JobStep.OnFailStep Property

Gets or sets the job step that is executed after the referenced job step finishes execution with a completion status of failure.

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

Syntax

'Bildirim
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property OnFailStep As Integer
    Get
    Set
'Kullanım
Dim instance As JobStep
Dim value As Integer

value = instance.OnFailStep

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

Property Value

Type: System.Int32
An Int32 value that specifies the ID value of the job step that is executed after the referenced job step finishes with failure.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

JobStep Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_help_jobstep (Transact-SQL)