Query to find jobs failed in the last hour

[Kumar Rahul]

Hi guys,

I know we can easily find this out through Process Monitoring but can we find this information through SQL query. Also is there any way to automate this report from process monitoring?

[Peter Grundler]

Hi Kumar,

you have to query the table AH. Use this page as reference.

You can also create a report using the DB.Reporting tool. Please check the functionality in the Automic documentation.

regards,
Peter

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

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

[Kumar Rahul]

Thank you for your response Peter. I tried creating a query in Db Reporting tool to get a list of failed jobs in the last hour. It does generate a csv file but the fields are blank. Am I missing something?

[Peter Grundler]

Hi Kumar,

can it be the case that there were no abnormal terminations?

Please provide the XML file created by the report designer so I can do a quick check.

regards,
Peter

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

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

[Kumar Rahul]

I have uploaded the file.

Attachment(s)

Job_Fail.s.xml   677 B 1 version

[Peter Grundler]

Thanks Kumar,

I have used your configuration file in my environment (12.3.9 hf2). The reporting tool has created this output:

Object name; Start time; End time; Activation time; Status
JOBS.WIN.NOT_OK;2023-02-04 07:24:23;2023-02-04 07:25:05;2023-02-04 07:23:28; ENDED_NOT_OK - aborted
JOBS.WIN.NOT_OK;2023-02-04 07:24:24;2023-02-04 07:25:14;2023-02-04 07:23:32; ENDED_NOT_OK - aborted

So your definition file is correct. Please check the following:

1. does AWI/process monitoring also show no entries
2. are you connected to the correct database (INI file)
3. is the client number correct
4. is you're not yet on 12.3.9 please download and install the utilities into a new directory and try with this version

regards,
Peter

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

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

[Kumar Rahul]

Thank you. I was choosing the wrong Client.