Find Workload Automation AE jobs created after a specific date

Document ID : KB000046258
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

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


Environment:  

CA Workload Automation AE r11.3.X

 

Answer: 

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;