Script to execute the Reporting services Subscription

• Narayana_17

  SSC Eights!

  Points: 933

  More actions

  October 15, 2010 at 3:06 am

  #228067

  Hi,

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

  Please help me in this.

  Thanks

  Narayana

• chris.smith 91049

  Old Hand

  Points: 327

  More actions

  January 22, 2014 at 6:24 am

  #1682363

  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