Automic Workload Automation

Expand all | Collapse all

SQL Query for statistics

Jump to Best Answer
  • 1.  SQL Query for statistics

    Posted 12-12-2018 11:42 AM

    Does anyone know a SQL query to pull the statistics for a specific job?

     

    My goal is to get all errors for a specific time frame for a specific set of job objects.

     

    Thank you in advance.

     

    EDIT:  ONE Automation 2015 - Automation Engine 11



  • 2.  Re: SQL Query for statistics

    Posted 12-12-2018 11:50 AM

    Hi MichaelDePew607911,

     

    As this is posted under the Automic Community space which has a few different "Automic" product line.  Can you let us know which product are you using/asking this SQL query for?

    Regards,
    Luu



  • 3.  Re: SQL Query for statistics

    Posted 12-12-2018 01:53 PM

    Yes, sorry about that:  ONE Automation 2015 - Automation Engine 11



  • 4.  Re: SQL Query for statistics

    Posted 12-12-2018 02:44 PM

    Thank you for the information, I have moved this post to the CA Automic Workload Automation space to better reach the product audience users.



  • 5.  Re: SQL Query for statistics
    Best Answer

    Posted 12-12-2018 03:41 PM

    Here is what I use (Oracle). Generally I variable the Start date, end date, and client within uc4:

     

     

    SELECT AH_NAME, AH_alias, AH_Status
    FROM AH
    WHERE AH_Timestamp4 between to_date('2018-12-10 00:00:00','yyyy-mm-dd HH24:MI:SS')
    and to_date('2018-12-12 23:59:59', 'yyyy-mm-dd HH24:MI:SS')
    and Ah_client = '<CLIENT>'
    and AH_Otype not in ('REPORT', 'CLNT', 'USER','QUEUE')
    and AH_Status NOT BETWEEN 1900 and 1999
    order by AH_NAME asc

     

    You can also add an AH_name condition to pick a specific job. 

     

    Schema for reference:

     

    AE Database 11.2  



  • 6.  Re: SQL Query for statistics

    Posted 12-12-2018 06:26 PM

    Ah yes, this is what I was looking for.  Thank you very much!