PLAN_JOBS_V

The PLAN_JOBS_V view displays information about jobs in plan.
Table 1. The PLAN_JOBS_V view
Column name Description Type Length
Job_id The job identifier. character 16
Job_workstation_id The identifier of the workstation of the job specified in the Job_id column. character 16
Job_workstation_folder_id The identifier of the folder containing the workstation of the job specified in the Job_id column. character 16
Job_workstation_folder_name The name of the folder containing the workstation of the job specified in the Job_id column. string 801
Job_workstation_name A hexadecimal identifier used in the Symphony file to identify the workstation of the job specified in the Job_id column. string 16
Job_workstation_original_name The identifier of the workstation of the job specified in the Job_id column. string 16
Job_name The name of the job specified in the Job_id column. string 40
Job_stream_workstation_id The identifier of the workstation of the job's job stream specified in the Job_id column. character 16
Job_stream_id The identifier of the job stream of the job specified in the Job_id column. character 16
Job_stream_wks_fol_id The identifier of the folder containing the workstation of the job's job stream specified in the Job_id column. character 16
Job_stream_wks_fol_name The name of the folder containing the workstation of the job's job stream specified in the Job_id column. string 801
Job_stream_workstation_name The name of the workstation of the job's job stream specified in the Job_id column. string 16
Job_stream_wks_orig_name The identifier of the original workstation of the job's job stream specified in the Job_id column. string 16
Job_stream_name The name of the job's job stream specified in the Job_id column. string 16
Scheduled_time The input arrival time of the job's job stream specified in the Job_id column. timestamp 10
Job_type The type of job specified in the Job_id column. string 50
Actual_start The time at which the job specified in the Job_id column actually started, if it has completed running. timestamp 10
Actual_end The time at which the job specified in the Job_id column actually finished, if it has completed running. timestamp 10
Deadline The time within which the job specified in the Job_id column must complete. timestamp 10
Earliest_start The date and time at which the job specified in the Job_id column is planned to start. timestamp 10
Estimated_duration The estimated run time for the job specified in the Job_id column. integer 12
Status The job status. Possible values are:
C
Canceled
H
Held
W
Waiting
B
Blocked
R
Ready
S
Running
O
Successful
E
Error
U
Undecided
X
Suppressed
character 1
Internal_status The job internal status. Possible values are:
A
Ready
B
Hold
C
Exec
D
Exec_bm
E
Stuck
F
Abend
G
Succ
H
Cancel
I
Unknown
J
User_stream
K
Cancel_p
L
Add
M
Restart_job
N
Fail
O
Mpe_susp
P
Mpe_wait
Q
Mpe_intro
R
Mpe_intro_bm
S
Mpe_waitd
T
Mpe_sched
U
Abend_p
V
Succ_p
W
End_p
X
Extrn
Y
Error
Z
Held
1
Jss
2
Fence
3
Bound
character 1
Job_number For UNIX, the process identification number (PID) of the job. For Windows, the an incremental number assigned by HCL Workload Automation. integer 10
Priority The priority assigned to the job specified in the Job_id column. integer 3
Original_priority The original priority assigned to the job specified in the Job_id column. integer 3
Return_code The return code assigned to the job specified in the Job_id column. integer 10
Record_number The record number. integer 12
Maximum_duration The maximum amount of time that the job run can last. integer 12
Minimum_duration The minimum amount of time that the job run must last. integer 12
Critical If the job is critical. Possible values are:
Y
Yes
N
No
character 1
Critical_latest_start The latest time that the specified in the Job_id column can start, so as to allow the critical job (for which this job is a predecessor) to complete successfully. timestamp 10
Monitored If the job is monitored. Possible values are:
Y
Yes
N
No
character 1
Promoted If the job is promoted. Possible values are:
Y
Yes
N
No
character 1
Every_frequency The time interval in hours and minutes between runs of the job specified in the Job_id column. integer 12
Latest_start The latest time that the job specified in the Job_id column can start, expressed in the time zone set. timestamp 10
Interactive If the job is interactive. Possible values are:
Y
Yes
N
No
character 1
Return_code_mapping The mapping between the job return code and the expression. string 256
Task_string The task that the job performs. string 1048576
Total_dependencies The total number of dependencies that depend on the job specified in the Job_id column. integer 5
Job_dependencies The number of jobs that depend on the job specified in the Job_id column. integer 5
Job_stream_dependencies The number of job streams that depend on the job specified in the Job_id column. integer 5
Internetwork_dependencies The number of internetwork jobs that depend on the job specified in the Job_id column. integer 5
Prompt_dependencies The number of prompts that depend on the job specified in the Job_id column. integer 5
Resource_dependencies The number of resources that depend on the job specified in the Job_id column. integer 5
File_dependencies The number of files that depend on the job specified in the Job_id column. integer 5
Not_satisfied_dependencies The number of dependencies that depend on the job specified in the Job_id column but that are not satisfied. integer 5
Login The name of the operating system user who launches the job specified in the Job_id column. string 47
Last_in_chain If the job is the last in the rerun chain. Possible values are:
Y
Yes
N
No
character 1
Rerun_type The job rerun type. Possible values are:
R
Rerun as
E
Rerun every
F
Rerun from
C
Recovery rerun
character 1
Recovery_option The job recovery option. Possible values are:
S
Stop
C
Continue
R
Rerun
character 1
Recovery_repeat_interval The interval in milliseconds after which a new execution of the job is launched if the job failed integer 12
Recovery_repeat_occurrences The number of maximum attempts to rerun the job if it failed integer 5
Recovery_repeat_affinity Specify whether the failed job must be rerun on the same workstation or the target workstation must be selected by the broker. Supported values are:
Y
Yes: rerun on the same workstation.
N
No: the target workstation must be selected by the broker.
character 1
Recovery_repeat_iterations The actual number of attempts to rerun the failed job integer 5
Recovery_job_id The identifier of the recovery job. character 16
Head_job_id The identifier of the head job of the rerun chain related to the job specified in the Job_id column. character 16
Head_job_name The name of the head job of the rerun chain related to the job specified in the Job_id column. string 40