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

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation

Issue/Introduction

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.

Environment

Workload Automation AE (AutoSys)

Resolution

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.