Jobs have default settings that are applied after a job is created. You can make changes to the default job settings using the Job Settings tab.
Field | Description |
---|---|
Priority | Set the relative priority for executing a job. Data Mover uses this priority to determine which jobs should be executed first when multiple jobs are in the execution queue. This priority is also used to determine which tasks are executed first. The options are Low, Medium, and High. The default is Medium. Jobs designated as high priority are started before lower priority jobs when they are queued to run. A column indicating job priority is available for display in the Saved Jobs view. |
Use Online Archive | Set read and write access to a source table while the table is copied to the target. Applies only to Teradata ARC jobs. You can update the source table during the copy process, but the changes are not transferred to the target table. Instead, the data contained in the target table matches the data that was in the source table at the beginning of the copy process. Online archiving demands more processing so expect job performance to be reduced. |
Logging Level | Set the amount of detail provided for job logging as follows:
|
Allow Overwrite | Set to overwrite tables and objects on the target automatically, if the target table or object exists. The following describes the behavior when moving join indexes, hash indexes, journals, and triggers to Teradata Database:
|
Compare DDL | Set to compare the DDL of source tables and views with those of their existing target tables and views. Views are compared only if their copyData attributes have been specified as true.
|
Event table logging | Set logging of events related to the job by clicking the Edit button and selecting one or more event tables. The options are displayed if event tables are specified in the Data Mover Setup portlet. |
Job Permissions | Set the read, write, and execute permission for users and roles. |
Use ARC ID pool | Set to make multiple users in a target system available for running a job. Applies only to Teradata ARC jobs. Before using this option in a job, the Teradata Viewpoint Administrator must first add user names and passwords for the target system in Data Mover Setup. |
Freeze job steps | Set to verify any changes in the source and target environments between the time the job was first created and the time it is run. If you select this option you can later update job steps from the Saved Jobs view. This option generally improves performance.
|
File Options | For Hadoop, select Text, RC, or ORC and any delimiters, such as comma (,). |
Foreign Server Name | Select the foreign server that was created to copy data between either Teradata and Teradata systems or Teradata and Hadoop systems. |
Query Band | Set to tag sessions or transactions with user-defined name-value pairs. If you define a query band for a job, Data Mover uses that definition for all transactions on the source and target systems for the job. |
Target Database | Set a default target database that is used for all database objects included in the job request. Click to select a database. You can use the filter to display only the items that match the characters you enter. |
Source staging Database for tables | Set a default source staging database that is used for all tables included in the job request. Click to select a database. You can use the filter to display only the items that match the characters you enter. |
Target staging Database for tables | Set a default staging database for tables that is used for all tables included in the job request. Click to select a database. You can use the filter to display only the items that match the characters you enter. |
Target staging Database for temporary artifacts | Set a default staging database for temporary artifacts, such as work tables, log tables, error tables, or macros. Click to select a database. You can use the filter to display only the items that match the characters you enter. |