We are seeking guidance on jobs that have been created before August of 2020 and also On Ice.
I have tried several queries but was unable to get accurate data.
Release : 11.3.6
Component : CA Workload Automation AE (AutoSys)
Run the following query for jobs that were created before August of 2020 and currently ON_ICE:
select job_name, CREATE_STAMP from ujo_job where joid in (select joid from ujo_job_status where status=7) and create_stamp < date '2020-08-01' and is_active=1 and is_currver =1;
Note: AEDB is running on Oracle.