Automic Workload Automation

Hello,

I am looking for database quereys.

• Jobs with status ended not ok or empty or skipped
• Scheduled Jobs without Workflows
• Top running Jobs ( Jobs running more often as 15 minutes)
• Cyclical (C_PERIOD) Tasks, running once a day

Thanks, Gregor

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

Hi Wolfgang,

thank you for your helf.

C) - Jobs running more often than 15 times.

Thanks, Gregor

Hi

V11.2 + MS SQL Server tested

adjust client Number to your needs.....

select eh_name, count(*) as 'Amount' from eh
where eh_client = 1
group by eh_name

Having
COUNT(*) > 15
order by 2  desc

cheers, Wolfgang