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 |