Script to execute the Reporting services Subscription

  • Hi,

    Is there any way to run the Reporting services Subscription using stored procedures or sql script.

    Please help me in this.



  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply