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

book

Article ID: 199735

calendar_today

Updated On:

Products

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

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

Release : 11.3.6

Component : CA 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.