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.
|Priority||Set the relative priority for starting a job. Data Mover uses this priority to determine which jobs to run first when multiple jobs are in the execution queue. This priority is also used to determine which tasks are run 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:
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 True 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, and triggers to Teradata Database when set to True:
|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.
|Database to Client Encryption||Set to enable encryption for a particular job, table, or view using any Data Mover interface.
|Copy Stats||Set to enable copy the statistics for a particular job or table using any Data Mover interface.
|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.|
|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 the job is run. If you select this option you can later update job steps from the Saved Jobs view.
This option generally improves performance.
|Foreign Server Name||Select the foreign server that was created to copy data between Teradata and Teradata systems.|
|Query Band||Set to tag sessions or transactions with user-defined name-value pairs in the format of key=value as comma-separated name 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.|