HCL Workload Automation, Version 9.4

PLAN_JOB_STREAM_PREDECESSORS_V

The PLAN_JOB_STREAM_PREDECESSORS_V view displays information about job and job stream predecessors of a job stream in the plan.
Table 1. The PLAN_JOB_STREAM_PREDECESSORS_V view
Column name Description Type Length
Job_stream_id The identifier of the job stream on which the dependency is defined. character 16
Job_stream_wks_id The identifier of the workstation of the job stream on which the dependency is defined. character 16
Job_stream_wks_name The name of the workstation of the job stream on which the dependency is defined. string 16
Job_stream_folder_id The identifier of the folder containing the job stream on which the dependency is defined. character 16
Job_stream_folder_name The name of the folder containing the job stream on which the dependency is defined. string

4000  Oracle
4095  DB2

Job_stream_name The name of the job stream on which the dependency is defined. string 16
Job_stream_pred_id The identifier of the job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_id The identifier of the job that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_js_wks_id The identifier of the workstation of the job's job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_js_wks_name The name of the workstation of the job's job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_pred_js_name The name of the job's job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_pred_js_sched_time The input arrival time of the job's job stream that depends on the job stream specified in the Job_stream_id column. timestamp 10
Job_pred_wks_id The identifier of the workstation of the job that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_wks_name The name of the workstation of the job that depends on the job stream specified in the Job_stream_id column. string 16
Job_pred_name The name of the job that depends on the job stream specified in the Job_stream_id column. string 40
Job_stream_pred_wks_id The identifier of the workstation of the job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_stream_pred_wks_name The name of the workstation of the job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_stream_pred_folder_id The identifier of the folder containing the job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_stream_pred_folder_name The name of the folder containing the job stream that depends on the job stream specified in the Job_stream_id column. string

4000  Oracle
4095  DB2

Job_stream_pred_name The name of the job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_stream_pred_sched_time The input arrival time of the job stream that depends on the job stream specified in the Job_stream_id column. timestamp 10
Satisfied If the job stream's dependency is satisfied. Possible values are:
Y
Yes
N
No
character 1
Status The job stream's dependency status. Possible values are:
S
Satisfied
N
Not_satisfied
U
Undecided
character 1
Dependency_type The job stream's dependency type. Possible values are:
I
Internal
J
External_job
S
External_job_stream
N
Internetwork
character 1
Is_conditional_dependecy The job stream's dependency is a conditional dependency. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_success The condition is on SUCCESS. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_abend The condition is on ABEND. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_fail The condition is on FAIL. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_execute The condition is on EXECUTE. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_suppress The condition is on SUPPRESS. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Join_name The name of the container of more of one conditional dependency. Valid only if the Is_conditional_dependency column is set to Y. string 16
Join_quantity The number of dependencies that must be satisfied in the join specified in Join_name. Valid only if the Is_conditional_dependency column is set to Y. integer 5
Output_cond_list The list of output conditions for this job stream dependency. Valid only if the Is_conditional_dependency column is set to Y. string 2000