JOB_HISTORY_V

The JOB_HISTORY_V view displays information about job history.
Table 1. The JOB_HISTORY_V view
Column name Description Type Length
Workstation_name The name of the workstation or workstation class where the job was scheduled to run. string 16
Job_stream_wks_name_in_run The name of the workstation or workstation class where the job stream ran. string 16
Job_stream_folder_name The name of the folder where the job stream that ran is contained. string 801
Job_definition_identifier The identifier of the job definition. character 16
Job_name The name of the job. string 40
Job_folder_id The identifier of the folder that includes the job for which you want information displayed. character 16
Job_folder_name The name of the folder containing the job for which you want information displayed. string 801
Job_run_date_time The date and time when the job ran. timestamp
26
In DB2®
35
In Oracle
Late_start_time How late the job started with respect to the latest start time. This time is expressed in milliseconds. integer 12
Late_end_time How late the job ended with respect to the deadline. This time is expressed in milliseconds. integer 12
Planned_duration The time that a job was expected to complete. This time is expressed in milliseconds. integer 12
Job_start_time The date and time when the job was scheduled to start running. timestamp
26
In DB2®
35
In Oracle
Job_end_time The date and time when the job was scheduled to stop running. timestamp
26
In DB2®
35
In Oracle
Workstation_name_in_run The name of the workstation or workstation class where the job ran. string 16
Actual_workstation_name_in_run The name of the workstation where the job actually ran. Useful for jobs defined on X-AGENT, POOL and D-POOL workstation types. string 16
Workstation_license_type The type of license associated with the Actual_workstation_name_in_run. Supported values are:
J
PER_JOB
S
PER_SERVER
character 1
Job_stream_name_in_run The name of the job stream to which the job belonged when it ran. string 16
Job_name_in_run The name of the job when it ran. string 40
Job_identifier_in_run The identifier of the job when it ran. character 16
Total_elapsed_time The amount of time that the job took to run, for this run. This time is expressed in milliseconds. integer 12
Total_cpu_time The total amount of CPU time the job used to run, for this run. This time is expressed in milliseconds. integer 12
Long_duration If the job lasted longer than planned. Possible values are:
Y
Yes
N
No
character 1
Job_status The status of the job. Possible values are:
A
Abend
S
Successful
U
Unknown
E
Error
character 1
Rerun_type The type of run associated with the job instance. Possible values are:
R
Rerun; the instance is a rerun of the job present in the plan.
E
Rerun every; the rerun of a job for which you defined an every option.
F
Rerun from; the rerun of a job for which you defined a from option.
C
Recovery: the job is a recovery job associated with the planned job.
N
Regular: the job is not a rerun
character 1
Rerun_number The position that this run has in the ordered list of all the runs if the job ran multiple times. integer 10
Return_code The return code assigned to the job instance. integer 10
Job_number The numeric identifier of the job instance. integer 10
Job_stream_instance_id The identifier of the job stream instance to which the job belonged when it ran. integer 20
job_critical_latest_time The latest date and time when the critical job should have started to complete on time. timestamp
26
In DB2®
35
In Oracle
Job_critical If the job was flagged as critical. Possible values are:
Y
Yes
N
No
character 1
Job_promoted If the job was promoted to prioritize its execution. Possible values are:
Y
Yes
N
No
character 1
Log_time The date and time when the job run is logged. timestamp
26
In DB2®
35
In Oracle
User_login The user name under which the job instance ran. string 47
Workstation_folder_id The identifier of the folder in which the workstation is defined. character 16
Workstation_folder_name The name of the folder in which the workstation is defined. string 801
Workstation_symphony_id An identifier used in the Symphony file to identify the workstation. string 16