motioneye
asked on
sql2014 exec updatesubsscription stored procedure
Guys,
There is one system stored procedure in Reportserver use to update the subscription where we can update the "TO" in the report delivery option. but in our ssrs server I have almost 400 subscriptions that I need to delete old email address and add new email address at "To" field.
so instead of doing this one by on in SSRS - Report delivery option page, can I do this via bulk update T-sql in Reportserver db ? I provide a screenshot so you guys know where I means by "To" in report delivery option page in SSRS.
There is one system stored procedure in Reportserver use to update the subscription where we can update the "TO" in the report delivery option. but in our ssrs server I have almost 400 subscriptions that I need to delete old email address and add new email address at "To" field.
so instead of doing this one by on in SSRS - Report delivery option page, can I do this via bulk update T-sql in Reportserver db ? I provide a screenshot so you guys know where I means by "To" in report delivery option page in SSRS.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER