CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008reporting
Nandun
Nandun

Reputation: 2042

SSRS Subscriptions - Daily Emails Within a Time Interval

I need to setup a subscription to an SSRS report that I have, so it would send emails Daily between 5PM and 5AM only. Is this supported by SSRS 2005 or 2008?

My only option right now is to set up 12 different copies of the report and have 12 different subscriptions, for 5PM, 6PM, 7PM...4AM, 5AM etc. I don't like this approach for the maintenance complexity it adds.

Is there a better way to do this?

Thanks, Nandun

Upvotes: 1

Views: 3241

Answers (1)

Ian Preston
Ian Preston

Reputation: 39566

Not through Report Manager; you've already seen that you have limited options there.

However, when you set up an SSRS subscription, behind the scenes it's just set up as a normal SQL Server job run through the SQL Server Agent - these jobs are set up under a GUID type name, i.e. something like 8DF42130-97D3-41F7-B3EF-72E48BFDFBFA.

This means that you can update the job schedule in Management Studio with a few more options:

enter image description here

You should be able to update a SSRS created subscription to suit your requirements.

Not sure why you can't just do this through Report Manager, but hopefully this will help.

Upvotes: 4

Related Questions