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
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
Yes, sorry about that: ONE Automation 2015 - Automation Engine 11
Thank you for the information, I have moved this post to the CA Automic Workload Automation space to better reach the product audience users.
Here is what I use (Oracle). Generally I variable the Start date, end date, and client within uc4:
SELECT AH_NAME, AH_alias, AH_StatusFROM AHWHERE 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 1999order by AH_NAME asc
You can also add an AH_name condition to pick a specific job.
Schema for reference:
AE Database 11.2
Ah yes, this is what I was looking for. Thank you very much!