Condividi tramite


JobStep.OnFailAction Property

Gets or sets the action to take when the job step finishes execution with failure.

Spazio dei nomi: Microsoft.SqlServer.Management.Smo.Agent
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintassi

'Dichiarazione
Public Property OnFailAction As StepCompletionAction
public StepCompletionAction OnFailAction { get; set; }
public:
property StepCompletionAction OnFailAction {
    StepCompletionAction get ();
    void set (StepCompletionAction value);
}
/** @property */
public StepCompletionAction get_OnFailAction ()

/** @property */
public void set_OnFailAction (StepCompletionAction value)
public function get OnFailAction () : StepCompletionAction

public function set OnFailAction (value : StepCompletionAction)

Valore proprietà

A StepCompletionAction object value that specifies the action to take when the referenced job step finishes execution with a completion status of failure.

Osservazioni

When a job step finishes execution it has status specified by the CompletionResult object value. This is recorded in the LastRunOutcome property for the job step when it was last executed. If the job step completed with failure, the next steps are determined by the OnFailAction property.

Questo spazio dei nomi, classe o membro è supportato solo nella versione 2.0 di Microsoft .NET Framework.

Esempio

How to: Create a Job with Steps and a Schedule in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

JobStep Class
JobStep Members
Microsoft.SqlServer.Management.Smo.Agent Namespace

Altre risorse

Scheduling Automatic Administrative Tasks in SQL Server Agent
Automatizzazione delle attività amministrative (SQL Server Agent)
sp_help_jobstep (Transact-SQL)