16.20 - Using Job Steps - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

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