Hi
all SQLs are tested with V11.2 ORA12C
A)
select eh_client, eh_name, eh_ah_idnr, eh_status from eh
where eh_status in (1800,1910,1930)
order by eh_client, eh_name, eh_status
B)
see https://communities.ca.com/thread/241805110
C)
not sure what you mean
- Jobs running more often than xy times
OR
- Jobs running longer than 15 Minutes?
cheers, Wolfgang