Steve Riedmueller sriedmue79
sriedmue79
/ Active Jobs.sql
Last active
November 13, 2023 19:39
IBM i - Various uses for the ACTIVE_JOB_INFO() table function
This file contains hidden or 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
| --------------------------------------------------------------------- | |
| -- 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 |
NewerOlder