How Run SSRS Subscrisions from a Stored Procedure
Hi ,
I have a Subscription, it is working fine if i schedule it...
But i want it to run from a stored procedure....
if i run that stored procedure ...Subscription should execute...
is there any Syntax to run a Subscription...
I am using SQL Server 2008 R2
Please help...................
Thanks in advance
Pavan
November 24th, 2011 2:25am
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/7cc7d5ec-c549-4944-8c5b-70c0a940978b
- Just
execute the script you created.
For test the subscription:
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/e20a6514-ab72-44c2-821d-24b106da447d
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2011 3:07am