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
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> ...