How to select paramin values from jobqueue?

I dig a bit and this is an answer on my question ;)

select q.UID_Tree, q.JobChainName, q.UID_Job, q.ComponentAssembly, q.TaskName, p.parametername, p.parameterValue --,p.*

from jobhistory q

cross apply [dbo].[QBM_FCVJobParameterToList](q.ParamIN) p

where
q.jobchainname = '<process name>'
and p.parametername = '<param name>'

order by 1,3,6

Great, very useful! Thank you for sharing!

Great, very useful! Thank you for sharing!