Scheduled Reports Not Being Sent Out

I have several scheduled reports that have been running every morning and being emailed out to many recipients. One day it all stopped. There are no error messages. It just doesn't work any more.

I have tried re-deploying them to the report server and rescheduling the jobs but they still don't run.

There are no error messages in the Reporting services log?

Is this RS 2005? I had a problem recently with the SMTP server name specified in the RS Config Tool, I had to use the IP address of the SMTP server rather than the name of it and it fixed the problem. It was something to do with a DNS issue we had.

Might be worth a try.

|||

Hi,

Same problem I have now as you had, I wonder how did you solve your problem.

Please advise,

Frank

|||There has to be some information in the error log of SQL Server Reporting services (stack trace or an informal message). Please post that here.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||All subscription schedules become SQL Agent jobs. You should look in SQL Agent to see if there is an issue with the jobs firing.