List of jobs where a parameter is used

[sweta rai]

Is there any way to find out ; all the datastage jobs where a particular parameter from a Parameter set is used ?

[BI-RMA]

In Advanced Find You can run a search for jobs using the parameter-set, but not the parameter itself.

Export all the jobs containing the paramter-set to a .dsx-file (design-only) and search the file for the name of the parameter.

[sweta rai]

Thanks for the Response .
But the list of jobs are huge . And again searching within the exported XML is a cumbersome process .
Is there any other alternative ?

[BI-RMA]

Hi Sweta,

not as cumbersome as You may think:

You can use DataStage to do the filtering.

Read the file sequentially, find the identifier in the line following the string "BEGIN_DSJOB", and write that to a Stage-variable.
In the following lines search for the parameter name using the Index()-Function. Set a stage-variable to True when the parameter name is found.

Write one row to the output for every job You find the parameter-name in. There is Your list...

[chulett]

Chuck Smith has already built that for you with his "DataStage tools" offerings. Check out the 'Search' or 'List' code... if it doesn't already do what you need, modify it so it does.

[ArndW]

Write a Server routine called FindParameter with one argument, 'Arg1' with the following code:

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H
EQUATE Comma TO ","
Ans = ""
JobList = DSGetProjectInfo(DSJ.JOBLIST)
JobCount = DCOUNT(JobList,Comma)
FOR i = 1 TO JobCount
   JobName   = FIELD(JobList,Comma,i)
   JobHandle = DSAttachJob(JobName,DSJ.ERRNONE)
   ParameterList = CONVERT(Comma,@FM,DSGetJobInfo(JobHandle,DSJ.PARAMLIST))
   LOCATE Arg1 IN ParameterList SETTING Pos ELSE Pos = 0
   IF Pos THEN Ans<-1> = JobName
   Dummy = DSDetachJob(JobHandle)
NEXT i
Ans = CONVERT(@FM,Comma,Ans)

It will return a comma separated list of jobs with the parameter passed in as a Arg1.