How to get the date of job creation and the date of it's last update

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

Question:

 

What is the SQL query to run to get the date of the job creation and the date of it's last update

 

Answer:

 

Autosys save the date of the creation and last update into ujo_job table

With Oracle you can try the following query to get all information:

select job_name, to_char(CREATE_STAMP,'DD/MM/YYYY HH24:MI:SS'),CREATE_USERID,to_char(UPDATE_STAMP,'DD/MM/YYYY HH24:MI:SS'), UPDATE_USERID from aedbadmin.ujo_job where is_active=1