Why are none of my scheduled reports running? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Patrick MurphyPatrick Murphy 

Why are none of my scheduled reports running?

Hi

For the last week or so none of my scheduled reports seem to be hitting my inbox. I checked one of the reports yesterday, nothing expired, no changes etc but nothing in my inbox. Yesterday I removed the schedule from one report, did a save as and then added the schedule but still nothing today.

Any ideas? Could something have been changed somewhere to stop these reports running? A few reports are really key as it tells us the position at 10pm which we can't replicate by running the next morning.

Thanks
Best Answer chosen by Patrick Murphy
Aleksandra RadovanovicAleksandra Radovanovic

Hi Patrick,

There are several things you can check to see what is happening with your scheduled reports.
1. Confirm that the schedule didn't expire - you said you already did that so we can cross that over.
2. Look in Setup > Monitor > Jobs > Scheduled Jobs to see if the report is scheduled to run again - that way you can confirm that system is working and that there are no problems with schedule.
3. Go to Setup > Monitor > Logs > Email Log Files and request an email log file for the day the report was supposed to be emailed, and the to/from user it was to be sent to. When the email log is ready, download it and unzip it. Then sort the report by Date Time and look around the time when the report was supposed to be sent. If it's in there, then your report was sent (or was attempted to be sent), but might have gotten hung up by your email server. If there was trouble sending, you'll see a number the "Retry" column.
4. Make sure that report didn't end up in Spam folder or that you don't have any Outlook rules that might re-direct email with report to other folders or emails. I
5. If all the above is working and you still don't see the reports being delivered to you, check with your IT team - email servers sometimes mark scheduled Salesforce reports as spam so they never gets delivered to user's inbox.
 

All Answers

Aleksandra RadovanovicAleksandra Radovanovic

Hi Patrick,

There are several things you can check to see what is happening with your scheduled reports.
1. Confirm that the schedule didn't expire - you said you already did that so we can cross that over.
2. Look in Setup > Monitor > Jobs > Scheduled Jobs to see if the report is scheduled to run again - that way you can confirm that system is working and that there are no problems with schedule.
3. Go to Setup > Monitor > Logs > Email Log Files and request an email log file for the day the report was supposed to be emailed, and the to/from user it was to be sent to. When the email log is ready, download it and unzip it. Then sort the report by Date Time and look around the time when the report was supposed to be sent. If it's in there, then your report was sent (or was attempted to be sent), but might have gotten hung up by your email server. If there was trouble sending, you'll see a number the "Retry" column.
4. Make sure that report didn't end up in Spam folder or that you don't have any Outlook rules that might re-direct email with report to other folders or emails. I
5. If all the above is working and you still don't see the reports being delivered to you, check with your IT team - email servers sometimes mark scheduled Salesforce reports as spam so they never gets delivered to user's inbox.
 

This was selected as the best answer
Arva ChunawalaArva Chunawala
Hi Patrick,
You could running up to your limit of scheduled reports.

Here is more information about scheduled reports limitations - 
https://help.salesforce.com/apex/HTViewSolution?urlname=Scheduled-Reports-Limitations-Considerations&language=en_US 

Hope this helps.

Thanks & Regards,
Arva
Patrick MurphyPatrick Murphy
I'm beginning to think this is something else as I have not had the notification emails to say you guys answered my question. I am not getting the email log files I created about an hour ago. I am getting all normal work related emails both internal and external so it must be SF related. And ideas?
Aleksandra RadovanovicAleksandra Radovanovic

I had a similar issue in my previous company - email spam filters on company emails were setup in a very strict way so anything with generic incmosing email address (e.g. reply@salesforce.com) was marked as suspicious and quarantined. Once the support team whitelisted salesforce.com emails everything worked perfectly.

You can try changing your Salesforce email to your Gmail (or whatever you use) and schedule test run for report to see if it's being delivered. If that works, definitely check with whoever is managing your company's email server since there's nothing you could do to fix it.

Patrick MurphyPatrick Murphy
OK, I have corrected it. For some reason my email was set as my username, I am wondering if something has now changed and this is why I am no longer getting anything. You can consider the question closed. Thanks.