ENDJOBSUCCESSROLLBACK

Description

This function returns #ENDJOBSUCCESS! which causes the job to stop with a successful result, returns a step outcome of Failure, and:

If transactions are enabled, previous steps (that have not been committed) are rolled back.
Insight logs the error message "Execution terminated due to the #ENDJOBSUCCESS! command".
When viewed in the Console Execution Log, the result displays as "Success w/info".

Insight determines the action to take depending on the Transaction value for Failure in the Flow Control table. For detailed information, see Flow Control Tab.

Note: This function provides the same functionality as ENDJOBSUCCESS, but has been renamed for clarity.

To return a step outcome of Success (0), use the ENDJOBSUCCESSCOMMIT function.

Syntax

ENDJOBSUCCESSROLLBACK ( )

Remarks

Note: This function requires special handling when working with bulk operations. See Using Bulk Operations for more information.