JOB_STATISTICS_V
The JOB_STATISTICS_V view displays runtime statistics for each job.
Column name | Description | Type | Length |
---|---|---|---|
JOB_NAME | The name of the job. | STRING | 8 |
ABENDED_RUNS | The number of times the job ended in error. | INTEGER | 10 |
LONG_DURATION_RUNS | The number of times the job duration exceeded the estimated duration, based on the long duration policy set in the DBOPT statement. | INTEGER | 10 |
SUCCESSFUL_RUNS | The number of times the job ran successfully. | INTEGER | 10 |
LATE_START_RUNS | The number of times the job started later than its latest start time. | INTEGER | 10 |
LATE_END_RUNS | The number of times the job ended later than its deadline. | INTEGER | 10 |
TOTAL_RERUNS | The total number of reruns. | INTEGER | 10 |
LAST_RUN_DATE | The actual start date and time of the last run. | TIMESTAMP | 10 |
LAST_ELAPSED_TIME | The actual duration of the last run. | INTEGER | 12 |
MIN_RUN_DATE | The actual start date and time when the job took the shortest time to run. | TIMESTAMP | 10 |
MIN_ELAPSED_TIME | The minimum duration run. | INTEGER | 12 |
MAX_RUN_DATE | The actual start date and time of the maximum duration run. | TIMESTAMP | 10 |
MAX_ELAPSED_TIME | The maximum duration run. | INTEGER | 12 |
AVERAGE_ELAPSED_TIME | The average duration. The scheduler calculates it considering only the successfully completed jobs, based on the smoothing policy set in the DBOPT statement. | 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. | INTEGER | 12 |