DSXchange

Posted: **Wed Feb 03, 2016 5:50 am**

Hi,

Good Day!,

Is there any Xmeta table which stores the runtime job parameter values of all jobs within a project?

Regards
Venkat

Posted: **Wed Feb 03, 2016 9:09 am**

Multiple executions of a job can have different runtime job parameter values. Are you using operations console? If yes, then use following query

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

Posted: **Thu Feb 11, 2016 1:47 am**

Thanks, Yes i am using operation console only. I will test the query and will contact you if any issues.

Thank you.

DSXchange

Xmeta table which stores run the time job parameter values

Xmeta table which stores run the time job parameter values