Is there a way to list the Jobs that have Before or After Exec Shell from a Project.
Thanks
Is there a way to find what jobs have Before/After Exec Shel
Moderators: chulett, rschirm, roy
Go to http://compilewitch.x2.nu/ and contact look through the screen and see if this is what you like to. If it is request a demo. The demo does fit your request but does not compile more than 5 jobs.
Wolfgang Hürter
Amsterdam
Amsterdam
Before routines are stored in field 9 and 10 has after routines in the ROOT record.
I stole this code from Ray's post yesterday. You can figure out after routines.
Code: Select all
SELECT EVAL "@RECORD<9>" AS BEFORE_ROUTINE
FROM DS_JOBOBJECTS
WHERE OBJIDNO = (SELECT JOBID FROM DS_JOBS WHERE NAME = '<<Job Name>>')
AND OBJIDNAME = 'ROOT' ;
Mamu Kim