https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403255#M18202 <P>How do we find the failures in the sys_trigger table to find that a scheduled job is failed.</P> <P>I have entered into the table 'sys_trigger.LIST' and provided the filter conditions as given in the screen print :</P> <P>1. Created on today</P> <P>2. State is Error&nbsp;</P> <P>But, I couldn't find any of the scheduled job record which is in the error state.</P> <P>Is this the correct way I'm looking for ?</P> <P>Why I'm not getting any error records, is there any other way to find the failed or error scheduled job ?</P> <P><span class="lia-inline-image-display-wrapper" image-alt="find_real_file.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/11470i4985BBB04711D2AA/image-size/large?v=v2&amp;px=999" role="button" title="find_real_file.png" alt="find_real_file.png" /></span></P> Thu, 26 Apr 2018 06:51:05 GMT Pravitha 2018-04-26T06:51:05Z https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403255#M18202 <P>How do we find the failures in the sys_trigger table to find that a scheduled job is failed.</P> <P>I have entered into the table 'sys_trigger.LIST' and provided the filter conditions as given in the screen print :</P> <P>1. Created on today</P> <P>2. State is Error&nbsp;</P> <P>But, I couldn't find any of the scheduled job record which is in the error state.</P> <P>Is this the correct way I'm looking for ?</P> <P>Why I'm not getting any error records, is there any other way to find the failed or error scheduled job ?</P> <P><span class="lia-inline-image-display-wrapper" image-alt="find_real_file.png"><img src="https://www.servicenow.com/community/image/serverpage/image-id/11470i4985BBB04711D2AA/image-size/large?v=v2&amp;px=999" role="button" title="find_real_file.png" alt="find_real_file.png" /></span></P> Thu, 26 Apr 2018 06:51:05 GMT https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403255#M18202 Pravitha 2018-04-26T06:51:05Z https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403256#M18203 <P>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.</P> Tue, 08 May 2018 10:40:09 GMT https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403256#M18203 Pravitha 2018-05-08T10:40:09Z https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403257#M18204 <P>Hi , Were you able to achieve this . I have a similar requirement to display any failed job over a period of time.</P> Mon, 18 May 2020 13:52:01 GMT https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403257#M18204 Kumar38 2020-05-18T13:52:01Z https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403258#M18205 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. Tue, 15 Dec 2020 20:18:31 GMT https://www.servicenow.com/community/service-management-forum/how-do-we-find-the-failures-in-the-sys-trigger-table-to-find/m-p/403258#M18205 Annay Das 2020-12-15T20:18:31Z