Hi,
Good Day!,
Is there any Xmeta table which stores the runtime job parameter values of all jobs within a project?
Regards
Venkat
Xmeta table which stores run the time job parameter values
Moderators: chulett, rschirm, roy
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