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?
我在相关问题中遇到了这个问题,基本上问了同样的问题。有没有办法将订阅导出和导入到SQL Server Reporting Services中创建的SharePoint托管报表?
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?
场景:在报告重新部署期间,将删除并重新创建报告,并删除关联的订阅(孤立?)。有没有办法(自动 - 通过自定义工具或通过SharePoint / SSRS API)我可以在删除关联报表之前导出订阅并在重新部署报表后导回订阅?
1 个解决方案
#1
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.
创建SSRS订阅时,将在SQL Server Agent \ Jobs下创建作业。作业名称看起来像一个guid,因此从另一个订阅一个订阅并不容易。但是您可以右键单击作业,并且可以使用“脚本作业”选项。
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. :)
我相信有更多T-SQL的人可以想出一个简洁的小脚本,为你做一切。但那将是一个全新的问题。 :)
Note: I know this for sure with SSRS 2005 I would image 2008 is similar.
注意:我对SSRS 2005肯定知道这一点,我想图像2008是类似的。
#1
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.
创建SSRS订阅时,将在SQL Server Agent \ Jobs下创建作业。作业名称看起来像一个guid,因此从另一个订阅一个订阅并不容易。但是您可以右键单击作业,并且可以使用“脚本作业”选项。
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. :)
我相信有更多T-SQL的人可以想出一个简洁的小脚本,为你做一切。但那将是一个全新的问题。 :)
Note: I know this for sure with SSRS 2005 I would image 2008 is similar.
注意:我对SSRS 2005肯定知道这一点,我想图像2008是类似的。