Specify Job Creation XML at Job Level | Teradata Data Mover - Job Level Specification Using Job Creation XML - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
Job Creation XML supports the following tags at the job level:
  • source_staging_database
  • target_staging_database or staging_database
  • staging_database_for_table
  • target_database
Data Mover supports using either the staging_database or target_staging_database tags to specify the target staging database, but not both at the same time.

When these values are specified, they are applied to all the table objects included in the job request. For non-table or view objects, if these values are supported, they need to be specified at the object level. These tags are optional, and must be positioned after the <force_utility> tag.

<overwrite_existing_objects>true</overwrite_existing_objects>
<force_utility>tptapi</force_utility>
<source_staging_database><name>stagingsourceDB</name></source_staging_database>
<target_staging_database><name>stagingtargetDB</name></target_staging_database>
<staging_database_for_table><name>stagingDBForTable</name></staging_database_for_table>
<target_database><name>targetDB</name></target_database>
...