emailreporting-servicessubscriptions

SSRS Email Subscription Not working


I'm trying to set up a couple of email delivery subscriptions to send out a few reports.

I have 1 fully working subscription that emails out every day at the same time. How ever if i try to create any more it fails. If i change the name of the report (with the working subscription) in any way it then fails until i undo any name changes that have been done.

Do i need to configure each report (the first subscription was already set up for me.)

I have tried making the new subscriptions but each time get a fail to send message.


Solution

  • If you don't use a shared data source you will need to configure the data connection report by report. Also, you need to set up the subscription one-by-one.

    If you have access, try to run a query for the execution log for more detailed information.

        USE ReportServer
        GO
        
        SELECT *
        FROM ExecutionLogStorage