Report Server/Scheduled Reports/Email

I'm guessing you guys aren't on RAMP? If you are they can certainly help you troubleshoot, otherwise I'd try to start with whatever machine or service is actually queuing your mail. That should give you answers like "never requested" or "file size too big". Maybe dbmail has logs somewhere also? That I don't know. In the past we've had issues with file size, but also with "from" address, in cases where that was cleared by whatever sending service we were using. Lastly, Report Server has always been a little flaky itself. Do you have evidence that the reports are being run as scheduled?

I'm guessing you guys aren't on RAMP? If you are they can certainly help you troubleshoot, otherwise I'd try to start with whatever machine or service is actually queuing your mail. That should give you answers like "never requested" or "file size too big". Maybe dbmail has logs somewhere also? That I don't know. In the past we've had issues with file size, but also with "from" address, in cases where that was cleared by whatever sending service we were using. Lastly, Report Server has always been a little flaky itself. Do you have evidence that the reports are being run as scheduled?

No, not on RAMP. I will check with IT about checking the logs. We do have evidence of the reports running as they are visible in Tools>View Reports, they just never emailed out. These are not new reports, and have sent in the past. Other emailed reports did send on the same days that these did not. All the email addresses are correct, but no one in the To on each report received them. As for file size, the one report is only 1 page long and as I mentioned has sent every day that it's been scheduled. Also of note is that this did not happen on the same day for these two different reports to not send. And yes, flaky is a 'nice' way of describing the report server...

We had a problem similar to this recently: we narrowed it down to the fact that the reports failing to send were going to different email addresses than the ones that succeeded. We then reviewed this with RAMP and determined that they had received some bounces from the mail service here on campus for those addresses, and had in turn blocked them.