JobStep.OnFailStep 屬性

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

命名空間：  Microsoft.SqlServer.Management.Smo.Agent
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property OnFailStep As Integer 
    Get 
    Set
'用途
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)

屬性值

型別：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.

範例

使用 SQL Server Agent 排程自動管理工作

請參閱

參考

JobStep 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)

sp_help_jobstep (Transact-SQL)