JOB_DEPS_V

The JOB_DEPS_V view displays information about jobs and job streams that depend on a job.
Table 1. The JOB_DEPS_V view
Column name Description Type Length
Type_of_dependency The type of dependency. Possible values are:
  • Internal job dependency
  • Internal conditional job dependency
  • External job dependency
  • External conditional job dependency
  • External job stream dependency
  • External conditional job stream dependency
 character 42
Job_identifier The identifier of the job on which the jobs and job streams depend. character 16
Job_name The name of the job on which the jobs and job streams depend. string 40
Job_stream_wks_identifier The identifier of the workstation where the job stream that contains the job on which the jobs and job streams depend is defined. character 16
Job_stream_wks_name The name of the workstation where the job stream that contains the job on which the jobs and job streams depend is defined. string 16
Job_stream_folder_id The identifier of the folder that includes the job stream containing the job on which the jobs and job streams depend. character 16
Job_stream_folder_name The name of the folder that includes the job stream containing the job on which the jobs and job streams depend. string 801
Job_stream_identifier The identifier of the job stream that contains the job on which the jobs and job streams depend. character 16
Job_stream_name The name of the job stream that contains the job on which the jobs and job streams depend. string 16
Dep_job_stream_wks_identifier The identifier of the workstation where the job stream that depends on the job specified in the Job_identifier column is defined. character 16
Dep_job_stream_wks_name The name of the workstation where the job stream that depends on the job specified in the Job_name column is defined. string 16
Dep_job_stream_folder_id The identifier of the folder containing the job stream that depends on the job specified in the Job_identifier column. character 16
Dep_job_stream_folder_name The name of the folder containing the job stream that depends on the job specified in the Job_identifier column. string 801
Dep_job_stream_identifier The identifier of the job stream that depends on the job specified in the Job_identifier column. character 16
Dep_job_stream_name The name of the job stream that depends on the job specified in the Job_name column. string 16
Dep_job_stream_valid_from The starting date from which the dependent job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Dep_job_stream_valid_to The last date that the dependent job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Dep_job_identifier The identifier of the job that depends on the job specified in the Job_name column. If this field is not displayed, the job or the job stream does not depend on any job. Character 16
Dep_job_name The name of the job that depends on the job specified in the Job_name column. If this field is not displayed, the job or the job stream does not depend on any job. string 40
Dep_job_critical The job specified in the Dep_job_name column is a critical job. Possible values are:
Y
Yes
N
No
 character 1
Conditional_dep_id The identifier of the dependency where the output conditions are specified. Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 character 16
Condition_on_success The condition on SUCCESS status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 character 1
Condition_on_abend The condition on ABEND status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 character 1
Condition_on_fail The condition on FAIL status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 character 1
Condition_on_execute The condition on EXECUTE status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 character 1
Condition_on_suppress The condition on SUPPRESS status is enabled. Possible values are:
Y
Yes
N
No
Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 character 1
Join_id The identifier of the join containing more than one conditional dependency. Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 character 16
Join_name The name of the join containing more than one conditional dependency. Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 string 16
Join_quantity The number of dependencies that must be satisfied in the join specified by Join_name. Valid only for the Type_of_dependency column:
  • Internal conditional job dependency
  • External conditional job dependency
  • External conditional job stream dependency
 integer 5
Job_stream_wks_folder_id The identifier of the folder containing the workstation of the job stream. character 16
Job_stream_wks_folder_name The name of the folder containing the workstation of the job's job stream. string 801
Job_stream_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job's job stream. string 16
Dep_job_stream_wks_folder_id The identifier of the folder containing the workstation of the job stream that depends on the job. character 16
Dep_job_stream_wks_folder_name The name of the folder containing the workstation of the job stream that depends on the job. string 801
Dep_job_stream_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job stream that depends on the job. string 16