I usually do this to run subscription based report based on SSIS package routine steps. This enables me to trigger subscription based report on demand when data has been refreshed on my Data warehouse.
Run this on Report server.
DECLARE @EVENTData varchar(100)
select @EVENTData=SubscriptionID from dbo.Subscriptions
where Description = ['Report subscription name']
PRINT @EVENTData
exec ReportServerDB.dbo.AddEvent @EventType='TimedSubscription', @EventData=@EVENTData
Run this on Report server.
DECLARE @EVENTData varchar(100)
select @EVENTData=SubscriptionID from dbo.Subscriptions
where Description = ['Report subscription name']
PRINT @EVENTData
exec ReportServerDB.dbo.AddEvent @EventType='TimedSubscription', @EventData=@EVENTData
