Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script to execute the Reporting services Subscription Expand / Collapse
Author
Message
Posted Friday, October 15, 2010 3:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:33 AM
Points: 21, Visits: 134
Hi,
Is there any way to run the Reporting services Subscription using stored procedures or sql script.

Please help me in this.

Thanks
Narayana
Post #1004979
Posted Wednesday, January 22, 2014 6:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 14, 2014 4:47 AM
Points: 11, Visits: 37
Sure;

USE ReportServer
DECLARE @SubScriptionID NVARCHAR(50)
SELECT @SubScriptionID = [SubscriptionID]

FROM [ReportServer$SQL2012].[dbo].[Subscriptions]
WHERE [Description] = '<your subscription description here>: you can use any other criteria, e.g. if you know the actual ID, use that'


EXEC dbo.AddEvent @EventType = 'TimedSubscription', @EventData=@SubScriptionID
Post #1533590
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse