The DEFINE JOB statement syntax order is important.
where:
| Syntax Element | Description |
|---|---|
| DEFINE JOB | Required keyword phrase specifying the beginning of the job definition. |
| DESCRIPTION 'descriptionString' | Optional keyword phrase providing a descriptive comment about the defined job object. |
| jobName | Required internal Teradata PT metadata name of the defined job object. The name does not have to be the same as the file name of the script. |
| SECONDS SEC |
Optional keyword indicating that the preceding value is expressed in seconds. |
| MINUTES MIN |
Optional keyword indicating that the preceding value is expressed in minutes. |
| SET jobVariable = ‘value’ | Optional job script specification to set any number of job variables and their default values. For more information, see the Teradata® Parallel Transporter User Guide, B035-2445. |
| STEP stepName | Required if there are multiple steps. Keyword phrase that names and introduces a job step. The stepName must be unique within the set of names of the steps in the job. |
| USING CHARACTER SET or USING CHAR SET charsetId | Optional keyword phrase preceding the DEFINE JOB statement that specifies the character set to be used for the job. This specification is needed only if you want to use an extended character set rather than the platform defaults of ASCII or EBCDIC. The charsetId is the name or code of the extended character set to be used for the job. |