List the sequencers which uses environmental variable

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

List the sequencers which uses environmental variable

Post by just4u_sharath »

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
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

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...
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

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
Post Reply