How do we find the failures in the sys_trigger table to find that a scheduled job is failed.

Pravitha
Tera Contributor

‎04-25-2018 11:51 PM

How do we find the failures in the sys_trigger table to find that a scheduled job is failed.

I have entered into the table 'sys_trigger.LIST' and provided the filter conditions as given in the screen print :

1. Created on today

2. State is Error 

But, I couldn't find any of the scheduled job record which is in the error state.

Is this the correct way I'm looking for ?

Why I'm not getting any error records, is there any other way to find the failed or error scheduled job ?

find_real_file.png

Preview file
22 KB
0 Helpfuls
  • 2,154 Views
3 REPLIES 3

Pravitha
Tera Contributor

‎05-08-2018 03:40 AM

Could any one of you please update the same - to find the failures in the sys_trigger table to find that a scheduled job is failed.

0 Helpfuls

Kumar38
Kilo Sage
In response to Pravitha

‎05-18-2020 06:52 AM

Hi , Were you able to achieve this . I have a similar requirement to display any failed job over a period of time.

0 Helpfuls

Annay Das
Tera Contributor

‎12-15-2020 12:18 PM

You need to bring in the columns "error count" and "error message" in sys_trigger table list view. Each time the job fails, error count is incremented and error message stores the details of the error like exception logs. Jobs which fail are not marked as "error", rather they are scheduled again (state=ready) for the next run. Definitely not very intuitive design by ServiceNow.
0 Helpfuls