Find Workload Automation AE jobs created after a specific date

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

We need a list of jobs that were created after July 24th.  How can we retrieve this data?

 

Environment

Workload Automation AE

Resolution

Run the following SQL query against your Autosys database. 

Oracle

SELECT JOB_NAME, CREATE_STAMP FROM AEDBADMIN.UJO_JOB WHERE CREATE_STAMP BETWEEN '24-JUL-16'   AND SYSDATE;

SQL Server

SELECT JOB_NAME, CREATE_STAMP FROM DBO.UJO_JOB WHERE CREATE_STAMP BETWEEN '2016-04-22 00:00:00'   AND CURRENT_TIMESTAMP;