routine_A used by what jobs?

[htrisakti3]

hi..
how do I list out what DSjobs use routine_A ?

currently, I export ALL to dsx, and build dsjob to read the dsx & output csv containing: jobname & all derivations. From there I do a search..

There must be easier way..

Thanx.

[ray.wurlod]

Get into the Administrator client. Execute the following command, as shown.

Code: Select all

SELECT NAME FMT '35L', CATEGORY FMT '35L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%<<Routine Name>>%');

You can substitute your routine name for <<Routine Name>> or, if you don't, the command will prompt you for it.
This query will return all jobs containing the name of the routine, whether it is used as a routine or not, but it will be close to what you have said you require. A variation might be to include the left parenthesis of the routine call.

Code: Select all

SELECT NAME FMT '35L', CATEGORY FMT '35L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%<<Routine Name>>(%');

[DS_SUPPORT]

Or the Usage Analysis from the Manager Client..