How to get the list of all the jobs ran since a specific date?
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 ;