SQL Query for statistics

[MichaelDePew607911]

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

[LuuLe]

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

[MichaelDePew607911]

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

[LuuLe]

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

[Michael Pirson]

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  

[MichaelDePew607911]

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