导出和导入对在 SQL Server Reporting Services 中创建的 SharePoint 托管报表的订阅
我在相关问题中遇到了这个问题这基本上问同样的事情。 是否可以导出和导入对在 SQL Server Reporting Services 中创建的 SharePoint 托管报表的订阅？
场景：在报表重新部署期间，报表被删除并重新创建，并且关联的订阅被删除（孤立？）。 有没有一种方法（自动化 - 通过自定义工具或通过 SharePoint/SSRS API）可以在删除关联报告之前导出订阅并在重新部署报告后导回订阅？
I came across this question in related questions which basically asks the same thing.
Is there a way of exporting and importing subscriptions to SharePoint-hosted reports that were created in SQL Server Reporting Services?
Scenario: During report re-deployments, reports are deleted and re-created, and the associated subscriptions are deleted (orphaned?). Is there a way (automated - either by a custom tool or via SharePoint/SSRS APIs) that I can export out the subscriptions before deleting the associated report and import back the subscriptions after the report has been redeployed?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
需要尝试的事情...
创建 SSRS 订阅时，会在 SQL Server Agent\Jobs 下创建一个作业。 作业名称看起来像一个指南，因此很难区分一个订阅和另一个订阅。 但您可以右键单击该作业，然后“将作业脚本编写为”选项可用。
我确信熟悉 T-SQL 的人可以想出一个简洁的小脚本来为您完成所有工作。 但这将是一个全新的问题。 :)
注意：我确信 SSRS 2005 是这样的，我想 2008 年也是类似的。
Something to try...
When a SSRS subscription is create a job gets created under SQL Server Agent\Jobs. The job name looks like a guid so it's not easy to tell one subscription from another. But you can right click on the job and the "Script Job as" options are available.
I'm sure someone with more T-SQL could come up with a neat little script that does everything for you. But that would be a whole new question. :)
Note: I know this for sure with SSRS 2005 I would image 2008 is similar.