15.10 - Using Job Steps - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

Using Job Steps

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 */
      );
);