The following sample XML illustrates the correct order of all possible elements available for a job creation XML file.
Refer to this sample XML before creating a job.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dmCreate xmlns="http://schemas.teradata.com/dataMover/v2009" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.teradata.com/unity/datamover.xsd">
<job_name>datamovertest</job_name>
<source_tdpid>dmdev</source_tdpid>
<source_user>dmguest</source_user>
<source_password>please</source_password>
<source_password_encrypted></source_password_encrypted>
<source_logon_mechanism></source_logon_mechanism>
<source_logon_mechanism_data></source_logon_mechanism_data>
<source_account_id></source_account_id>
<source_session_charset></source_session_charset>
<target_tdpid>dmsmp2</target_tdpid>
<target_user>dmguest</target_user>
<target_password>please</target_password>
<target_password_encrypted></target_password_encrypted>
<target_logon_mechanism></target_logon_mechanism>
<target_logon_mechanism_data></target_logon_mechanism_data>
<target_account_id></target_account_id>
<target_session_charset></target_session_charset>
<use_userid_pool>false</use_userid_pool>
<data_streams>1</data_streams>
<source_sessions>1</source_sessions>
<target_sessions>1</target_sessions>
<max_agents_per_task>1</max_agents_per_task>
<response_timeout>100</response_timeout>
<sync>true</sync>
<overwrite_existing_objects>true</overwrite_existing_objects>
<freeze_job_steps>false</freeze_job_steps>
<force_utility>tptapi</force_utility>
<staging_database>
<name>dmguest</name>
</staging_database>
<staging_database_for_table>
<name>dmguest</name>
</staging_database_for_table>
<target_database>
<name>dmguest</name>
</target_database>
<log_level>0</log_level>
<online_archive>false</online_archive>
<log_to_event_table>tmsmevent</log_to_event_table>
<database selection="unselected" replaceDatabase="true">
<name>dmguest</name>
<staging_database>
<name>dmguest</name>
</staging_database>
<staging_database_for_table>
<name>dmguest</name>
</staging_database_for_table>
<target_database>
<name>dmguest</name>
</target_database>
<compare_ddl>TRUE</compare_ddl>
<table selection="included" copyStats="false">
<name>ppiorders</name>
<staging_database>
<name>dmguest</name>
</staging_database>
<staging_database_for_table>
<name>dmguest</name>
</staging_database_for_table>
<force_target_staging_table>false</force_target_staging_table>
<target_database>
<name>dmguest</name>
</target_database>
<target_name>table8_clone</target_name>
<validate_row_count>all</validate_row_count>
<override_lock_access>false</override_lock_access>
<export_without_spool>true</export_without_spool>
<compare_ddl>TRUE</compare_ddl>
<sql_where_clause><![CDATA[ WHERE ORDERDATE > '2003-01-23' ]]></sql_where_clause>
<key_columns>
<key_column>ORDERDATE</key_column>
</key_columns>
<staging_to_target>insert_only</staging_to_target>
</table>
<table selection="included" copyStats="false">
<name>employee</name>
<compare_ddl>true</compare_ddl>
</table>
</database>
<triggers>
<trigger selection="included">
<database>dmguest</database>
<subject_table_database>dmguest</subject_table_database>
<table>employee</table>
<name>TestTrigger</name>
<action_time enabled="NO">BEFORE</action_time>
</trigger>
</triggers>
<indices>
<index selection="included" copyStats="false">
<name>Orders_HI</name>
<target_name>orders_HI_new</target_name>
<index_database>dmguest</index_database>
<index_type>HASH_INDEX</index_type>
</index>
</indices>
<views>
<view selection="included" copyData="true">
<name>testview</name>
<database>dmguest</database>
<view_data_table>
<target_table>TargetTable</target_table>
<target_database>dmguest</target_database>
</view_data_table>
<staging_database>
<name>dmguest</name>
</staging_database>
<staging_database_for_table>
<name>dmguest</name>
</staging_database_for_table>
<force_target_staging_table>false</force_target_staging_table>
<validate_row_count>all</validate_row_count>
<compare_ddl>true</compare_ddl>
<sql_where_clause><![CDATA[ WHERE "test2"."C1" > 500 ]]></sql_where_clause>
<key_columns>
<key_column>C1</key_column>
</key_columns>
</view>
</views>
<foreign_servers>
<foreign_server selection="included" >
<name>FSObj</name>
<map>map1</map>
<colocate>col1</colocate>
</foreign_server>
</foreign_servers>
<function_aliases>
<function_alias selection="included" >
<name>dmguest</name>
<database>faObj</database>
</function_alias>
</function_aliases>
<macros>
<macro selection="included">
<name>macro_employee</name>
<database>dmguest</database>
</macro>
</macros>
<stored_procedures>
<stored_procedure selection="included">
<name>getEmpInfo</name>
<database>dmguest</database>
</stored_procedure>
</stored_procedures>
<uowid>test</uowid>
<query_band>AppName=B;</query_band>
</dmCreate>