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

Answer this question

SQL Reporting Services Subscription Does Not Work

Ant&#243;nio Pinho
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.
Joanne A.
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 then look 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 :)
Youssef Abou-Kewik

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 fired
2. Look in the Reporting Services log file to see if it fired (and if so, if there is an error)
Guy Mahieu
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
Andres_Ghelarducci
did you ever find an answer to this I am having the same problem.... it is driving me crazy.
SQL Reporting Services Subscription Does Not Work

Answer this question