News
Abstract
The JOB_INFO table function returns one row for each job meeting the selection criteria. It returns information similar to what is returned by the Work with User Jobs (WRKUSRJOB), Work with Subsystem Jobs (WRKSBSJOB), and Work with Submitted Jobs (WRKSBMJOB) CL commands and the List Job (QUSLJOB) API.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.JOB_INFO()
For complete detail, visit this IBM Documentation page: JOB_INFO table function
Enhanced with IBM i 7.6 SF99960 Level 1 & IBM i 7.5 SF99950 Level 9 & IBM i 7.4 SF99704 Level 30:
- Add job name filter
Enhanced with IBM i 7.4 SF99704 Level 13 and IBM i 7.3 SF99703 Level 24:
- Add the JOB_NAME_SHORT, JOB_USER, and JOB_NUMBER columns
[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Was this topic helpful?
Document Information
Modified date:
30 March 2025
UID
ibm11128615