Xmeta table which stores run the time job parameter values

venkat626 · Post by **venkat626** » 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

rkashyap · Post by **rkashyap** » 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

venkat626 · Post by **venkat626** » 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.