Udostępnij za pośrednictwem


IDTSEvents.OnExecutionStatusChanged Method

Called by a task or container when its execution status changes.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Sub OnExecutionStatusChanged ( _
    exec As Executable, _
    newStatus As DTSExecStatus, _
    ByRef fireAgain As Boolean _
)
void OnExecutionStatusChanged (
    Executable exec,
    DTSExecStatus newStatus,
    ref bool fireAgain
)
void OnExecutionStatusChanged (
    Executable^ exec, 
    DTSExecStatus newStatus, 
    bool% fireAgain
)
void OnExecutionStatusChanged (
    Executable exec, 
    DTSExecStatus newStatus, 
    /** @ref */ boolean fireAgain
)
JScript does not support passing value-type arguments by reference.

Parameters

  • exec
    The task raising the event.
  • newStatus
    The current status of the executable.
  • fireAgain
    A Boolean that indicates this should continue firing or stop firing. A value of true indicates that it should continue firing.

Remarks

The following table shows the values that newStatus will contain:

newStatus

Description

Abend

The task experienced an internal error and terminated execution abnormally.

Completed

Task has completed executing with a success or failed result.

Executing

Task is currently running.

None

Task is idle. Default value.

Suspended

Task is currently suspended because of a breakpoint hit.

Validating

Task is currently validating.

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

IDTSEvents Interface
IDTSEvents Members
Microsoft.SqlServer.Dts.Runtime Namespace