Hi All,
I need to get a list of Jobs with specific App code and latest end time.
I used following query, however I'm not getting the jobs which are not executed even once as null and I'm getting duplicate entries.
Please help. It's urgent.
select oh_name as "Jobname"
,(select ah_timestamp4 from ah a where oh_idnr=a.ah_oh_idnr) as "Last Run"
,eca_value "Appcode"
,jfa_filenamedst "Filename"
from oh
left join jfa on jfa_oh_idnr=oh_idnr
left join ah on ah_oh_idnr=oh_idnr
left join eca on eac_ah_idnr=ah_idnr
where oh_otype='JOBF'
and eca_value='DELL'
oh_deleteflag=0
order by 1
/
------------------------------
Thanks,
Tom
------------------------------