JOB_STATISTICS_V

The JOB_STATISTICS_V view displays information about jobs.
Table 1. The JOB_STATISTICS_V view
Column name Description Type Length
Workstation_name The name of the workstation or workstation class where the job was defined. string 16
Job_definition_identifier The identifier of the job definition. character 16
Job_name The name of the job. string 40
Job_description A description of the job. string 120
Job_login_user The user name under which the job runs. string 47
Job_script_name The script or the command that the job runs. string
4095
In DB2®
4000
In Oracle
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
Recovery_job_definition_id The identifier of the job definition to be run, if the job specified in the job_definition_identifier column ends abnormally. character 16
Recovery_job_name The name of the job to run if the job specified in the Job_name column ends abnormally. string 40
Recovery_option The recovery options for the job. Possible values are:
C
Continue
R
Rerun
S
Stop
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 launch 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_prompt The text of the recovery prompt to display if the job ends abnormally. string 200
Job_modify_user The name of the user who created or modified the job definition. string 50
Successful_runs The number of times the job ran successfully. integer 10
Abended_runs The number of times the job ended abnormally. integer 10
Long_duration_runs The number of times the jobs with long duration ran. integer 10
Suppressed_runs The number of jobs that have been suppressed, that is the number of jobs whose until time has been reached, but the job has not yet started. integer 10
Late_start_runs The number of times the jobs ended after the latest start time was reached. integer 10
Late_end_runs The number of times the jobs ended after the deadline was reached. integer 10
Total_reruns The total number of times the job reran. integer 10
Averarage_cpu_time The average amount of CPU time the job took to run. This time is expressed in milliseconds. integer 12
Average_elapsed_time The average time the job took to run. This time is expressed in milliseconds. integer 12
Total_elapsed_time The sum of the times the job used the CPU and the time the job waited for other processes to release the CPU for all its runs. This time is expressed in milliseconds. integer 12
Total_cpu_time The total amount of CPU time the job used to run, for all its runs. This time is expressed in milliseconds. integer 12
Last_cpu_time Specifies how much CPU time the job used the last time it ran. This time is expressed in milliseconds. integer 12
Last_elapsed_time The elapsed time recorded during the job last run of the job. This time is expressed in milliseconds. integer 12
Last_run_date The date and time the job last ran. timestamp
26
In DB2®
35
In Oracle
Max_cpu_time The maximum CPU time recorded for all the job runs. This time is expressed in milliseconds. integer 12
Max_elapsed_time The maximum elapsed time recorded for all its runs. This time is expressed in milliseconds. integer 12
Max_run_date The date and time when the job took the longest time to run. timestamp
26
In DB2®
35
In Oracle
Min_cpu_time The minimum CPU time recorded for all the runs. This time is expressed in milliseconds. integer 12
Min_elapsed_time The minimum elapsed time recorded for all its runs. integer 12
Min_run_date The date and time when the job took the shortest time to run. timestamp
26
In DB2®
35
In Oracle
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