run_job | Teradata DSA Commands - 17.20 - run_job - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Last Update
2022-11-14
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)
Last Update
2022-11-14

Purpose

The run_job command runs a job as soon as all necessary resources are available. The DSC system limit is set at 20 concurrent running jobs, and up to 20 jobs can queue over that limit. The DSC also queues jobs if the defined target media is not available before the job starts.

Syntax

run_job -n|-name JobName -b|backup_type BackupType -p|-preview -r|runtime -f|-file File -w|wait -q|query_status -u|user_authentication User -I|original_job_execution_ID -j|job_phase JobPhase -R|restart

Examples

dsc run_job -n job1 -b cumulative -p -f file1.xml

dsc run_job -n job3 -b cumulative -I 13

dsc run_job -n job5 -R -w -q

Parameters

n|name Name
The name of the job on which to perform the action. Must be unique for each job.
Example: job1
b|backup_type BackupType
Enter the type of backup: full , delta , or cumulative
Example: delta
p|preview
[Optional] Generates an XML file that lists the job plan and settings. When the -r parameter is also used, a job plan is generated that includes only systems and media servers that are online. If the -r parameter is not used, the job plan includes all systems and media servers, even if they are not online.
r|runtime
[Optional] Checks to see if any of the media servers or systems are down, then generates a job plan to include only those online media servers or systems. To use the r parameter, you must also select the -p parameter.

For NetBackup and DDBoost, if disable_gen_zero is true in the target group configuration, backup jobs are rejected if any media server is offline. If disable_gen_zero is false, the job runs with a warning message.

f|file filename
[Optional] If you are previewing the job, this is the file path and file name of the output file to save the job plan.
Example: job1.xml
w|wait
[Optional] Waits until the job has run, then displays a brief status, such as COMPLETED_ERRORS. You can add the -q parameter for a more detailed status. You cannot use the wait parameter with the preview parameter.
q|query_status
[Optional] Returns full status after the job has run. Status includes the percentage of completion and elapsed time of the job run. To use this parameter, you must also select the -w parameter.
R|restart
Restarts a restore job that failed, aborted, or completed with errors or warnings. Only restores the objects that were not restored.
u|user_authentication User
Required when security management is enabled. Supplies the command with the Viewpoint user, and triggers a password prompt for authentication.

Permissions required: DSA Job Permissions: Run

-I |job_execution_ID jobID_of_original_full_backup_job
The run_job command with the -I option is not intended to be mixed with delta or cumulative backup job executions. Running delta or cumulative operations after a backup that uses the -I option results in backups that cannot be restored or that result in an incomplete restore, including loss of data in the restored objects.
[Optional] Runs a backup or restore job with the objects that were skipped in the original full backup job. The new job contains only the skipped objects. The job execution ID must be from:
  • A job that completed with errors or warnings
  • A job with skipped objects
  • The job specified with the -n option
The save set containing the skipped objects is not a base for delta or cumulative backup jobs, that is, the next backup for the job must be a full backup.
To obtain a job execution ID, you can use the list_job_history command.
If you run the backup job using the -I option, but the job completes with errors, you can use the original save set and run the job again with the -I option. The save set that results from running the job again includes the objects that were skipped in the original execution that completed with errors. The newly-generated save sets, together with the original save sets, are correlated and are required when restoring any object defined in the backup job definition.
Example: # dsc run_job -n LV500001 -I 13

Usage Notes

If disable_gen_zero is true in the target group configuration, backup jobs are rejected if any media server is offline. If disable_gen_zero is false, the job runs with a warning message.

The run_job command cannot be used successfully for a retired job.

DSA allows users to run jobs when there are down AMPs in the system.
  • Backup jobs are not rejected. Tables that have fallback protection are backed up as usual. Tables without fallback protection are skipped.
  • Restore jobs are not rejected. Tables without fallback protection are skipped.
  • CBB backup is rejected, since there is no way to keep track of WLSNs of down AMPs.

XML File Example

This command does not require an XML file as input. You must supply a file name and location to which the XML file results are exported as output.