How to get the list of all the jobs ran since a specific date?

Products

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

Issue/Introduction

How to get the list of all the jobs ran since a specific date?

Environment

WAAE 11.3.5 and 11.3.6 Release

Resolution

You can proceed by the following steps to get the list of all the jobs ran since a specific date:

Example: Since 1 December 2017

 

1.  Run the “time0” command to get the internal format for the date 1 December 2017:

 

$ time0 -T "12/01/2017 00:00:00"

 CAUAJM_I_50099 Autotime(internal): 1512104400

 

2. Then run the following query which will return the list of all the jobs ran since 1 December 2017:

 

select distinct(job_name) from ujo_job, ujo_job_runs where ujo_job.joid = ujo_job_runs.joid and ujo_job_runs.startime > 1512104400 ;