The Job Settings tab is available when creating or cloning a job and allows you to select and define job settings for backup, restore, and analyze jobs.
| Field | Description | Job Type |
|---|---|---|
| Automatically Retire | Determines whether a job is retired automatically.
|
|
| Backup Method | Determines the type of backup to perform.
|
|
| No sync checkbox | Determines where synchronization is done for the job. Only available for online backup jobs.
|
|
| Logging Level | Determines the types of messages that the database job logs.
|
|
| Job Permissions |
Click Edit to define or change permissions. |
|
| Abort On Access Rights Violation |
This checkbox appears only when the following are true:
|
|
| Query Band | Allows tagging of sessions or transactions with a set of user-defined name-value pairs to identify where a query originated. These identifiers are in addition to the current set of session identification fields, such as user ID, account string, client ID, and application name.
Valid query band values are defined on the database.
DSA creates query bands for restore jobs when an override temperature or block level compression option has a value other than DEFAULT. You can enter different query bands in the bottom text box. |
|
| Run as copy checkbox | When checked allows the restore to run as a copy job.
Do not use Run as copy when the database system is the original database and the database ID matches the one found in the backup save set.
|
Restore |
| Disable Fallback checkbox | Fallback protection means that a copy of every table row is maintained on a different AMP in the configuration. Fallback-protected tables are always fully accessible and are automatically recovered by the system.
|
Restore |
| DBC Credentials | DBC only backup. Click Set Credentials to open the Enter Credentials dialog box if DBC credentials need to be established. | Restore |
| Advanced Settings button | ||
| Track empty tables | Tracks empty tables during a backup job. Supported in Teradata Database 16.0 and later. |
Backup |
| Skip statistics | Skips collecting statistics during a backup or restore job. Supported in Analytics Database 16.20 and later / Teradata Database 16.0 and later. |
|
| Enhanced Locking Management checkbox | Checked. DSA locks one object at a time. The object is unlocked once it is backed up. DSA does not manage data consistency. Unchecked. DSA locks all objects at the beginning of the backup. The object is unlocked once it is backed up. This ensures data consistency between objects. |
Backup (offline only) |
| Override Temperature | Determines the temperature at which data is restored.
|
Restore |
| Block Level Compression | Defines data compression used.
|
Restore |
| Concurrent Builds Per Table | Number of index and fallback subtables that can be built concurrently per table during restore. Supported in Analytics Database 16.20 and later / Teradata Database 16.0 and later. |
Restore |
| Map to a different database on destination system | Database name to map to. | Restore |
| Limit the maximum streams per node for this job | When checked, overrides the system level stream soft limit. Range is 1 to 1 - max of the stream soft limit, where max is the number of AMPs per node in the system. Job level entry overrides the system level setting.
|
|
| Skip join/hash index | When checked, skips archiving the join and hash index during a backup job or skips restoring the join index during a restore job. |
|
| Skip build secondary indexes [Analytics Database 16.20 Update 2] |
When checked, skips building secondary indexes during incremental restore. | Incremental Restore |