Is there a way to find what jobs have Before/After Exec Shel

DS4DRIVER · Post by **DS4DRIVER** » Thu Jan 05, 2006 8:35 am

Is there a way to list the Jobs that have Before or After Exec Shell from a Project.

Thanks

ArndW · Post by **ArndW** » Thu Jan 05, 2006 9:08 am

I would to an export into a .DSX or .XML file and then use string searches to find those jobs that do so. There is no builtin method to do this.

WoMaWil · Post by **WoMaWil** » Thu Jan 05, 2006 10:02 am

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.

DS4DRIVER · Post by **DS4DRIVER** » Thu Jan 05, 2006 10:04 am

Is there a way using Universe Query or Use Basic COmmands?

ArndW · Post by **ArndW** » Thu Jan 05, 2006 10:09 am

I think it can be done with a query since the data is actually contained within the DS_JOBOBJECTS hashed file, and I know it can be done with a BASIC program.

kduke · Post by **kduke** » Thu Jan 05, 2006 8:08 pm

Before routines are stored in field 9 and 10 has after routines in the ROOT record.

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' ;

I stole this code from Ray's post yesterday. You can figure out after routines.