Automic Workload Automation

 View Only
  • 1.  Query all job reports after internal error that did not fail task

    Posted Aug 25, 2022 12:49 PM
    Using v12.3

    Hello,

    I have 50 or so RA jobs that make a connection to a file server.  These jobs all have a filter to look for certain failures in the OutPut scan that do not fail the job.  It works fine except when there is a new error.  (I will update my filter for future use.)

    Last night I got a new error.  What I would like to do is query all job reports to find which jobs encountered the error so I can re-run them?  

    I have seen posts refering to the RT table and recommending not using it.  What query does the Filter object use to read reports? 

    Thanks
    Tim

    ------------------------------
    Developer
    State of Colorado
    ------------------------------


  • 2.  RE: Query all job reports after internal error that did not fail task

    Posted Oct 01, 2022 06:11 AM
    Hi Tim,

    you can start using this query:

    select OH_Client, OH_Name, OPPF_Fltrname, OPPF_Result, OPPF_Retcode, AH_TimeStamp1, AH_Status, AH_RetCode
    from OH
    inner join OPPF on (OH_Idnr = OPPF_OH_Idnr)
    inner join AH on (OH_Idnr = AH_OH_Idnr)

    regards,
    Peter

    ------------------------------
    Automic Certified Professional & Expert & Knight

    For AUTOMIC trainings please check https://www.qskills.de/qs/workshops/automic/
    ------------------------------