DSXchange

Posted: **Thu Feb 22, 2018 12:31 pm**

Hello,
I am trying to list all the sequencer jobs that uses the FTP_EPSILON_HOST user defined environmental variable.

I asked the Admin to run the below command but it did not list any sequecers even though we have many jobs.

DS_JOBS WITH JOBTYPE = 2 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',14,'X')" LIKE FTP_EPSILON_HOST

http://www-01.ibm.com/support/docview.w ... wg21618535

Please correct me if there is any issue with the command.

Thanks

Posted: **Thu Feb 22, 2018 5:29 pm**

Try

Code: Select all

LIST DS_JOBS WITH JOBTYPE = 3 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',14,'X')" LIKE ...FTP_EPSILON_HOST...

Posted: **Thu Feb 22, 2018 5:51 pm**

Alternatively, if you are using Operations Console, then you can modify following query to get the desired result

Code: Select all

SELECT 
       H.HostName 
     , J.ProjectName 
     , J.JobName 
     , P.ParamName 
     , P.ParamValue 
     , R.InvocationId 
     , R.RunStartTimeStamp 
     , R.ElapsedRunSecs 
FROM  
       DSODB.JobExec J 
     , DSODB.JobRun R 
     , DSODB.Host H
     , DSODB.JobRunParamsView P 
WHERE  H.HOSTID = J.HOSTID 
  AND  R.JOBID = J.JOBID 
  AND  R.RUNID = P.RUNID

DSXchange

List the sequencers which uses environmental variable

List the sequencers which uses environmental variable