Scheduler Queries

Find status of your jobs based on job name:


select * from SCHSTATUS WHERE SCSJOBNBR IN (SELECT SCCJOBREFNUM FROM SCHCONFIG WHERE SCCSTART = '2014-06-02'  AND SCCPATHINFO = 'SomeCmd')

Find active jobs based on job name

SELECT * FROM SCHACTIVE WHERE SCSJOBNBR IN (SELECT SCCJOBREFNUM FROM SCHCONFIG WHERE SCCPATHINFO = 'SomeCmd')