I Need a table with the following Information
JobName, Value of Parameter1, Value of Parameter2, NextSubmitBaseTime
I tried this with the following query
select j.Description, jp.InValueString, j.NextSubmitBaseTime from Job j, JobParameter jp where jp.Job = j.UniqueId and j.Description like 'SERACHSTRING'
But so I get all Parameters and not only Parameter 1 and 2.
How I have to change the query?