sriedmue79

-------------------------------------------------------------------------
-- Description: queries related to subsystem autostart job entries (AJEs)
-------------------------------------------------------------------------

--Description: list the autostart job entries that are defined for a given subsystem description
SELECT *
    FROM QSYS2.AUTOSTART_JOB_INFO
    WHERE SUBSYSTEM_DESCRIPTION_LIBRARY = :SBSD_Library AND
          SUBSYSTEM_DESCRIPTION         = :SBSD_Name;

sriedmue79

---------------------------------------------------------------------
-- Description: Various uses for the ACTIVE_JOB_INFO() table function
---------------------------------------------------------------------

--Description: check whether a job (by job name) is currently active in a particular subsystem
SELECT JOB_NAME
    FROM TABLE ( QSYS2.ACTIVE_JOB_INFO( JOB_NAME_FILTER       => :JobName, 
                                        SUBSYSTEM_LIST_FILTER => :SubsystemName ) );

--Description: Jobs in a subsystem that are in a specific status