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