Extract SAP jobname and redwood jobname

[Gabie]

Hello Experts,

We have a requirement to extract the list of jobs with definition and it's sap Jobname.

Can somebody help me extract these details with the help of query report or redwood script?

Any help will be greatly appreciated.

Thanks

Gabie

[gmblom · Accepted solution]

Hello

You can use the following query to get this:

select jd.Name, jdp.DefaultExpression
from JobDefinition jd, JobDefinitionParameter jdp
where jd.BranchedLLPVersion = -1
and jd.UniqueId = jdp.JobDefinition
and jdp.Name = 'JOBNAME'

Regards Gerben

[Gabie · Accepted solution]

Thanks Gerben