Scheduled report ends in error

[JeanClaudeS]

How can I be alerted when a scheduled report ends in error or does not run at all?

[Matthew_13]

Hi Buddy,

ServiceNow doesn’t have a built-in way to alert you if a scheduled report fails or doesn’t run at all. If a report errors out, it usually does so silently.

The most reliable way to handle this is to add monitoring around the report execution itself. You can use a scheduled job or a Flow to check when the report last ran successfully and compare that to when it should have run. If there’s no successful execution within the expected time window, you can trigger an email, event, or even create an incident.

Some teams also look at outbound email failures if the report is emailed, but that only catches delivery problems and won’t help if the report never started or failed before generating the email.

So: if you need confidence that scheduled reports are actually running, you have to actively monitor their execution history and alert when it’s missing or shows an error.

@JeanClaudeS - Please mark Accepted Solution and Thumbs Up if you found Helpful 🙂

[Nayan ArchX]

Great question — ServiceNow doesn’t automatically notify you when a scheduled report fails, but you can absolutely set this up with a couple of solid approaches. I’ll start with the cleanest / most reliable method and then give alternatives.

BEST PRACTICE: Monitor Scheduled Report Execution

Every scheduled report creates a record in the Report Execution table.

Key tables

• sys_report
• sys_report_run (may be)

This covers all failure modes.

Scenario	Solution
Report errors	Business Rule on sys_report
Report doesn’t run	Scheduled Script
Out-of-box alert	❌Not available

Note: Some tables are highly restricted in access by ServiceNow due to the Performance Optimization: ServiceNow advises against reporting on large system tables, as doing so can slow down or crash the instance.

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

Thanks

Nayan Patel

IT ServiceNow Consult, ServiceNow ArchX

If my response has resolved your query, please mark it Helpful by giving it a thumbs up and Accept the Solution

[Ankur Bawiskar]

@Nayan ArchX 

I couldn’t find the table sys_report_run in the instance.
It would be helpful if you could provide accurate, validated information along with screenshots supporting your approach. This helps the person who raised the question.

[JeanClaudeS]

Hello,
I also can't find the sys_report_run table in my instance.