job_status_log | Teradata DSA Commands - job_status_log - BAR - Data Stream Architecture

Purpose

The job_status_log command displays the latest status log for a job with the given name if the job is running. If the job is not running, the status log for the last run job is displayed.

Syntax

job_status_log -n|-name Name -I|-job_execution_id JobExecutionID -E|-full_export -m|-hashmap MapName -C|-cumulative

Example

dsc job_status_log -n job1 -I 123456 -m specialmap

dsc job_status_log -n restore1 -I 465 -E -C

Parameters

n|name Name

The name of the job on which to perform the action. Must be unique for each job.

Example:  job1

I|job_execution_id Job Execution ID

[Optional] The execution ID for the job. Must be an integer.

The ID must match a version number listed in the list_save_sets command output for the same job.

Example:  2

B|backup_repository

[Optional] Flag to return status on repository backup jobs.

b|bucket BucketNumber

[Optional] Select a bucket number to display a grouping of data when too many results return to display at once. The command output notifies you if there are more buckets of data to display.

m|hashmap map name

[Optional] For backup jobs, lists the objects by the specified hash map used during the backup job. Default: All maps used in the backup job are listed.

E|full_export

[Optional] Retrieve and output the entire job status log to a landing zone on the DSC server to avoid the message size limit. The output file is a comma-separated value with the file name: <job_name>_<job_execution_id>.csv. The default landing zone directory is /var/opt/teradata/dsa/export. You can change the directory in dsc.property using the fullExport.landingZone property.

This parameter works only for BACKUP, RESTORE, and ANALYZE_VALIDATE jobs on the Advanced SQL Engine / Teradata Database. It does not work for DBC repository backup jobs.

C|cumulative

[Optional] Flag to return cumulative job status for a restore job that has been restarted. Status is provided up to the last completed restore.

XML File Example

This command does not support an XML file.