Getting statistics for jobs that have ended Simon Hutchinson

​One of the new additions to Db2 for i, or SQL, in the latest Technology Refreshes, IBM i 7.5 TR3 and 7.4 TR9, is a new Table function ENDED_JOB_INFO. This Table function exists in the SYSTOOLS library. ENDED_JOB_INFO allows me to retrieve some information about jobs that have, as the name suggests, ended.
ENDED_JOB_INFO has two parameters:

START_TIME:  The start of the range of jobs to find. If a job starts on or after this time it will be included in the results. If no value is given the default is the current timestamp less one day.
END_TIME:  End of the range. If no value is given the default is ‘9999-12-30-’.

Read more » Read More 

Verified by MonsterInsights