bdietz400 · July 26, 2021 14:37
diff --git a/When was the Last IPL b/When was the Last IPL
 --  description: LAST_IPL.sql
 -- Analogus to the CL I created years ago:
 -- that calls API QUSRJOBi against job 000000/QSYS/SCPF using format JOBi0400


 SELECT Job_Entered_System_Time AS Last_Ipl
    FROM TABLE(Qsys2.Job_Info(Job_Status_Filter => '*ACTIVE', Job_User_Filter => 'QSYS')) X
    WHERE Job_Name = '000000/QSYS/SCPF' ;
	-- description: LAST_IPL.sql
	-- Analogus to the CL I created years ago:
	-- that calls API QUSRJOBi against job 000000/QSYS/SCPF using format JOBi0400


	SELECT Job_Entered_System_Time AS Last_Ipl
	FROM TABLE(Qsys2.Job_Info(Job_Status_Filter => '*ACTIVE', Job_User_Filter => 'QSYS')) X
	WHERE Job_Name = '000000/QSYS/SCPF' ;