SSRS Hourly Schedule Once A Week

[Damiankk]

I need to create a schedule that runs a report once an hour on Fridays. The hourly schedule does not provide a way to select days of the week. Does anyone have a solution or am I missing something?

 

[guitarzan8]

If you have SQL Server Agent running (on the Server with your relational DB), you can create a Job in there to run your report. Create a subscription for your report, schedule it to run once, set the date to yesterday. In the ReportServer database in SSMS it will create a subscription_id for the subscription. You execute the report from your Job Step using this subscription_id.


exec ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='E4FB7DAF-C81B-4B07-84F2-BC3D097A4290'

where @EventData = the subscription_id you got from the subscription table.

 

[Damiankk]

So far it is working fine. Thank you.

Do I need the original Agent job that was set up through SSRS subscriptions or can I delete? This is the job I got the "where @EventData = the subscription_id you got from the subscription table." I didn't know if the new job I created is somehow dependent on the subscription job when calling the subscription_id.