HCL Workload Automation, Version 9.4

PLAN_JOB_STREAMS_V

The PLAN_JOB_STREAMS_V view displays information about job streams in the plan.
Table 1. The PLAN_JOB_STREAMS_V view
Column name Description Type Length
Job_stream_id The job stream identifier. character 16
Workstation_id The identifier of the workstation of the job stream specified in the Job_stream_id column. character 16
Workstation_name The name of the workstation of the job stream specified in the Job_stream_id column. string 16
Job_stream_folder_id The identifier of the folder containing the job stream specified in the Job_stream_id column. character 16
Job_stream_folder_name The name of the folder containing the job stream specified in the Job_stream_id column. string

4000  Oracle
4095  DB2

Job_stream_name The name of the job stream specified in the Job_stream_id column. string 16
Scheduled_time The input arrival time of the job stream specified in the Job_stream_id column. timestamp 10
Internal_identifier The unique alphanumerical job stream identifier that is automatically generated by HCL Workload Automation and assigned to the job stream. character 16
Actual_start The time at which the job stream specified in the Job_stream_id column actually started, if it has completed running. timestamp 10
Deadline The time within which the job stream specified in the Job_stream_id column must complete. timestamp 10
Earliest_start The date and time at which the job stream specified in the Job_stream_id column is planned to start. timestamp 10
Latest_start The latest time at which the job stream specified in the Job_stream_id column must be completed. timestamp 10
Estimated_duration The expected duration time of the job stream specified in the Job_stream_id column. integer 12
Jobs_limit The number of jobs in the job stream specified in the Job_stream_id column that can run concurrently. integer 4
Status The job stream 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 stream 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
Late If the job stream is late. Possible values are:
Y
Yes
N
No
character 1
Monitored If the job stream is monitored. Possible values are:
Y
Yes
N
No
character 1
Original_job_stream The original name of the job stream, for job streams that are submitted with an alias name. string 16
Record_number The record number. integer 12
Elapsed_time The amount of time that the job stream took to run, for this run. integer 12
Priority The priority assigned to the job stream specified in the Job_stream_id column. integer 3
Original_priority The original priority assigned to the job stream specified in the Job_stream_id column. integer 3
Total_jobs The number of total jobs in the job stream specified in the Job_stream_id column. integer 10
Abend_jobs The number of abended jobs in the job stream specified in the Job_stream_id column. integer 10
Executing_jobs The number of executing jobs in the job stream specified in the Job_stream_id column. integer 10
Failed_jobs The number of failed jobs in the job stream specified in the Job_stream_id column. integer 10
Successful_jobs The number of successful jobs in the job stream specified in the Job_stream_id column. integer 10
Not_running_jobs The number of not running jobs in the job stream specified in the Job_stream_id column. integer 10
Undecided_jobs The number of undecided jobs in the job stream specified Job_stream_id column. integer 10
Total_dependencies The number of dependencies of the job stream specified in the Job_stream_id column. integer 5
Job_dependencies The number of job dependencies of the job stream specified in the Job_stream_id column. integer 5
Job_stream_dependencies The number of job stream dependencies of the job stream specified in the Job_stream_id column. integer 5
Internetwork_dependencies The number of internetwork dependencies of the job stream specified in the Job_stream_id column. integer 5
Prompt_dependencies The number of prompt dependencies of the job stream specified in the Job_stream_id column. integer 5
Resource_dependencies The number of resource dependencies of the job stream specified in the Job_stream_id column. integer 5
File_dependencies The number of file dependencies of the job stream specified in the Job_stream_id column. integer 5
Unresolved_dependencies The number of unresolved dependencies of the job stream specified in the Job_stream_id column. integer 5
Timezone Time zone of the job stream specified in the Job_stream_id column. string 40