AutoSys Workload Automation

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Report to pull the jobs which are added recently

  • 1.  Report to pull the jobs which are added recently

    Posted Sep 03, 2019 03:18 PM
    Hello Team , 

    Can anyone help to pull the jobs which are recently added in Autosys .

    For Example 

    JoB1 and Job2 are added in 2nd of September 2019 .

    Job 3 is added on 4th September 2019 

    I would like to fetch the job name and the total number of jobs /box increased.

    ------------------------------
    Thanks and Regards
    Pratap
    ------------------------------


  • 2.  RE: Report to pull the jobs which are added recently
    Best Answer

    Posted Sep 04, 2019 01:52 AM
    Edited by Diane Craddock Sep 11, 2019 11:48 AM
    Hey Patrap,

    You can easliy get the data from the DB.

    We are using ORACLE DB (i guess it should be slimier in MS SQL)

    this query will return only jobs created in the last 30 days

    SELECT *
    FROM AEDBADMIN.UJO_JOB
    WHERE CREATE_STAMP > trunc(sysdate - 30)

    Hope it helps :)

    Yoni
    Bezeq international
    Original Message