I need to create multiple SSRS report subscriptions but to avoid creating associated multiple Delivery Schedules and corresponding Agent Jobs (otherwise there are just too many Agent Jobs).
The plan is to use our own scheduling windows service. Later to execute/create the report I want to use
or exec ReportServer.dbo.AddEvent 'TimedSubscription', @SubscriptionGuid .
to invoke a subscription.
How to programmatically create multiple SSRS Subscriptions without creating multiple Delivery Schedules and associated multiple SQL Agent jobs?