Using Job Steps - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

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