This topic has not yet been rated - Rate this topic

JobStep.OnSuccessAction Property

SQL Server 2008 R2

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

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

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public StepCompletionAction OnSuccessAction { get; set; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.Agent.StepCompletionAction
A StepCompletionAction object value that specifies the action to take when the referenced job step finishes execution with a completion status of success.

Remarks

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 success, the next steps are determined by the OnSuccessAction property.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

Reference

JobStep Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automating Administrative Tasks (SQL Server Agent)

sp_help_jobstep (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD