SSRS订阅

SSRS订阅 - 时间间隔内的每日电子邮件(SSRS Subscriptions - Daily Emails Within a Time Interval)

我需要设置我所拥有的SSRS报告的订阅，因此它只会在每天下午5点到5点之间发送电子邮件。 这是否得到SSRS 2005或2008的支持？

我现在唯一的选择是设置12个不同的报告副本，并有12个不同的订阅，下午5点，下午6点，下午7点......上午4点，上午5点等。我不喜欢这种方法，因为它增加了维护的复杂性。

有一个更好的方法吗？

谢谢，南盾

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

最满意答案

不通过报告管理器; 你已经看到你在那里的选择有限。

但是，当您设置SSRS订阅时，它只是设置为通过SQL Server代理运行的正常SQL Server作业 - 这些作业是在GUID类型名称下设置的，例如8DF42130-97D3-41F7-B3EF-72E48BFDFBFA 。

这意味着您可以使用更多选项更新Management Studio中的作业计划：

您应该能够更新SSRS创建的订阅以满足您的要求。

不知道为什么你不能通过Report Manager这样做，但希望这会有所帮助。

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:

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.