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
List the sequencers which uses environmental variable
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
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...
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