SQL Reporting Services Subscription Does Not Work
We have two SQL Reporting Services Servers (Test and Production). In the Test environment I have set up some subscriptions to email reports to me, it works great.I have tried to set up reports in the Production environment, but the Report Manager never even attempts to email a report to me. For example, this morning at 8:30 I set up a subscription to email a report to me at 8:45. It is now 9:15. I have not received the report. My Subscriptions shows the subscription, the Trigger is TimedSubscription, Last Run is blank, Status is New Subscription.Any one seen this behavior before?
September 23rd, 2005 5:14pm

Sounds like the event is not getting triggered by SQL Server Agent. You can:1. Look in the Agent Job History to see if it fired2. Look in the Reporting Services log file to see if it fired (and if so, if there is an error)
Free Windows Admin Tool Kit Click here and download it now
September 24th, 2005 8:26am

did you ever find an answer to this? I am having the same problem.... it is driving me crazy.
November 1st, 2005 6:10pm

I am currently having this issue and have been ripping my hair out all day trying to troubleshoot it... Has anyone come across a solution to this yet??
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2006 12:35am

Heya -- This could happen for a number of different reasons. Per Brian's suggestion, you should begin by making sure the event is even getting fired, and thenlook at the latest ReportServerService.log file found in the \logfiles folder. Without info from one of these two places, it's anyone's guess what your specific problem might be :)
January 26th, 2006 1:12am

I found that when I edited a previous "Once" Schedule that the start day remained the same, so when editing a "Once" schedule edit both time and start day.
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2006 6:22am

Hi All, I had met the same problem which my SQL Reporting Services Subscription does not work too. Is it because of the credential problem or? I had tried to troubleshoot it and doing research but still cannot solve the problem. Please help! Thanks for any reply.
November 8th, 2010 3:19am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics