ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Guidance on query for jobs created before a certain date and OI


Article ID: 199735


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent CA Workload Automation AE


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.