bryan_d bdietz400
bdietz400
/ Active jobs in MSGW
Created
January 15, 2020 18:58
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- category: Bryan.Dietz | |
| -- description: Jobs in msgw(wrkactjob) | |
| SELECT Job_Name | |
| ,Subsystem | |
| ,Function_Type CONCAT '-' CONCAT Function AS "Function" | |
| ,Job_Status | |
| ,(SELECT Message_Text | |
| FROM TABLE (Qsys2.Joblog_Info(I.Job_Name)) A | |
| ORDER BY Ordinal_Position DESC |
NewerOlder