Job steps are executed in the order in which they appear within the DEFINE JOB statement. Each job step must complete before the next step can begin. For example, the first job step could execute a DDL operator to create a target table. The second step could execute a Load operator to load the target table. A final step could then execute a cleanup operation.
The following is a sample of implementing multiple job steps:
DEFINE JOB multi-step ( DEFINE SCHEMA...; DEFINE SCHEMA...; DEFINE OPERATOR...; DEFINE OPERATOR...; STEP first_step ( APPLY...; /* DDL step */ ); STEP second_step ( APPLY...; /* DML step */ ); STEP third_step ( APPLY...; /* DDL step */ ); );