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

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

book

Article ID: 44407

calendar_today

Updated On:

Products

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

Issue/Introduction

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

 

 

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component:

Resolution

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