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  viewColumn 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

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