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

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

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

Environment:
WAAE 11.3.5 and 11.3.6 Release
Answer:

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 ;