Scheduled Email report is not running

[Dileep2]

Hi All,

Scheduled Email of report is not sending the report to users as specified. It should send report even if there are no records.

I have checked all the below conditions 

1. Run as user - User profile is active and having all roles

2. Omit if no records is unchecked - Then it should send reports daily even if empty

I have checked this article - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0535174 

But no luck.

Please suggest.

[Shriyansh]

Hi @Dileep2 ,

Can you please share screenshot of the scheduled report.

Regards,

Shriyansh

[Dileep2]

Hi Shriyansh,

Please see the screenshot attached.

[AndersBGS]

Hi @Dileep2 ,

Is it all that doesn't received it or is it only some? Does all receive the report if there is no data, or is it both with and without data that all doesn't receive the report? 

By the way, you have the possibility to remove the "run as", then the report will still run as default admin so you don't have to think about roles etc.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Amit Gujarathi]

Hi @Dileep2 ,
I trust you are doing great.

irstly, I recommend checking the scheduled job log to see if there are any error messages or exceptions that may be preventing the report from being sent. To do this, navigate to System Scheduler > Scheduled Jobs and search for the job in question. From there, you can view the job log and see if there are any issues.

If there are no errors in the job log, I suggest checking the email settings for the report. Make sure that the email is being sent to the correct recipient(s) and that the email content is properly configured. Also, ensure that the email server is configured correctly and is functioning properly.

If the above steps do not resolve the issue, you may need to look into scripting options to force the report to be sent even if there are no records. One option is to use a Business Rule to check if there are any records in the report and, if not, still send the email with a message indicating that there are no records.