2

I want to be able to deploy a report and this deploy should take care of the an email subscription and set the report run schedule; I shouldn't have to manually create a subscription later on and if a new subscription is to be applied, I should be able to update the subscription with report deploy only. If somebody could provide a generic subscription element template to copy and paste in the rdl file, will be a great help.

Constantevol
  • 21
  • 4

3 Answers3

0

Subscriptions are not part of the RDL file.

There is no way you can do what you want if you want it to deploy using right-click:deploy.

If you are using some automated process for deployment (rs.exe, SSRS webservice etc), you can set up subscriptions, but it would be a lot of work

Trubs
  • 2,829
  • 1
  • 24
  • 33
  • Could you provide some ideas on setting up subscriptions through automated process? Could adding a post-deployment script to the report project be one of the possible solutions? I appreciate your help. – Constantevol Mar 31 '15 at 12:19
  • a post deployment script wouldn't work, there are way to many dependencies in the db to make this feasible. maybe this could point you in the right direction http://www.ericwitkowski.com/2013/05/an-introduction-to-querying-and.html – Trubs Apr 10 '15 at 04:56
0

From everything I have found, I do not see how you can create a subscription. I have found a lot on altering an existing subscription though: https://msdn.microsoft.com/en-us/library/dn747196.aspx#bkmk_how_to

No instruction of rCREATING via PS, only mods: https://msdn.microsoft.com/en-us/library/ms156307(v=sql.130).aspx

James.Smith
  • 139
  • 2
  • 7
-1

you may be able to create the subscription ion a STAGE environment then transfer it to Prod as part of your post deployment

James.Smith
  • 139
  • 2
  • 7