AutoSys Workload Automation

 View Only

Difference betwen view ujo_jobst,ujo_job_runs,ujo_sched_info and ujo_job

  • 1.  Difference betwen view ujo_jobst,ujo_job_runs,ujo_sched_info and ujo_job

    Posted 10 days ago

    Hi all!

    I tryint to get a query (I don´t have access to autorep) to get the detail and historical from one job but I have some doubts about these tables, does anyone else have the data diccionary to validate the difference betwen these tables?

    For example , to get the historical previous execution I guess I need to get from ujo_job_runs and to get the last execution (just the last one) is from view ujo_jobst, that´s right? 

    What is the difference with ujo_job and why ujo_jobst , this one just have relationship with ujo_sched_info and not with ujo_job_runs ?

    Thanks in advance!