在 SSRS 中自定义共享计划
有人知道创建更复杂的共享时间表的方法吗？如果没有，您是否知道一种简化我在下面详细介绍的计划需求的方法？
与特定于报表的计划相比，在 sql server 2008 的 SSRS 中创建共享计划似乎不会带来任何额外的复杂性。
我真正需要的是能够创建与我公司的财务日历相关的时间表。例如，如果有一个在每个财政月结束时发送报告的时间表，那就太好了。另一个例子是全天通过电子邮件发送的报告，以提供运营更新。该报告发送的时间间隔与我在下面的配置屏幕中可以表达的任何内容都不相符，而是符合业务需求。例如，周一，报告将在上午 8:15、中午 12:15、下午 2:15、下午 4:15、下午 6:15 和晚上 9:15 发送。我无法确定如何在一个计划中完成此模式，因此我使用多个计划。由于一周中不同日期的模式不同，因此需要许多时间表。添加或删除收件人时，管理效率低下且麻烦。
当第一次了解到可以在服务器上配置共享计划时，我认为这些问题都会得到解决。我对下面的选项感到失望。 “脚本”菜单项在整个过程中保持灰色，因此修改将生成的代码似乎也不是一个选项。
谢谢！
Does anyone know of a way to create more complex shared schedules? If not, do you know of a way to simplify the schedule needs I have detailed below?
Creating a shared schedule in sql server 2008's SSRS does not seem to offer any additional complexities compared to report-specific schedules.
What I really need is the ability to create a schedule tied to my company's fiscal calendar. For example, it would be great to have a schedule that would send a report at the close of every fiscal month. Another example is of a report that emails throughout the day to provide operational updates. The report sends in intervals that do not align to anything I can express in the below configuration screen but rather to business needs. On Monday for example, the report will send at 8:15 AM, 12:15 PM, 2:15 PM, 4:15 PM, 6:15 PM and 9:15 PM. I cannot determine how to accomplish this pattern in one schedule, so I use multiple. Since the pattern is different for different days of the week, many schedules are needed. This is inefficient and cumbersome to manage when adding or removing recipients.
When first learning of shared schedules that could be configured on the server, I thought these problems would be solved. I am disappointed with the options below. The "Script" menu item remains gray through the process, so modifying the code this would generate does not appear to be an option either.
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
正如 Crispalot 爵士在评论中指出的那样，您无法将 SSRS 时间表修改到这种程度。除了每个报告的单个计划之外，共享计划不提供任何选项。
但您可以更改执行订阅的 SQL 代理的计划。您可以在此处将多个计划与订阅关联。
另一种方法是使用其他代码动态更改订阅及其计划，例如按计划运行或由 SQL 代理调用的 .NET .exe。您可以为所有报告构建一个非常好的计划界面，按照您喜欢的方式存储计划，然后动态更改订阅本身：http://www.codeproject.com/KB/reporting-services/DynamicSSRSSubscriptions.aspx
As Sir Crispalot notes in comments, you can't modify the SSRS schedule to this degree. A Shared Schedule doesn't give any options beyond the single schedule per report.
But you can change the schedule of the SQL agent that executes the subscription. Here you can associate multiple schedules with a subscription.
Another approach is to dynamically change the subscriptions and their schedules with some other code, such as a .NET .exe running on a schedule, or called by a SQL Agent. You could build a pretty nice scheduling interface for all your reports, storing the schedules however you like, then dynamically changing the subscriptions themselves: http://www.codeproject.com/KB/reporting-services/DynamicSSRSSubscriptions.aspx