How to schedule SSRS Report

Question

How to schedule SSRS Report

Ganesh Lohani

Hall of Fame

Points: 3091
More actions
October 15, 2009 at 2:12 pm

#227141

Hello
How to schedule SSRS report to run (in email delivery option) every Monday and Tuesday and every hour between 6:00 AM and 6:00 PM?
For example:
Monday- 6 AM, 7 AM, .............5 PM, 6 PM.
Tuesday- 6 AM, 7 AM, .............5 PM, 6, PM.

Viewing 8 posts - 1 through 7 (of 7 total)

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

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

I'm reaching a little here but if I remember these would be subscriptions in SSRS, the parameters would need to be the same but I'm pretty sure you can do it that way.

CEWII

Ganesh Lohani Hall of Fame Points: 3091 More actions · Answer 2

Please elaborate your idea. I need to set up it for next week.

Thanks

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Start here:

http://msdn.microsoft.com/en-us/library/ms159271(SQL.90).aspx

CEWII

David Smithson SSC Veteran Points: 201 More actions · Answer 4

You may want to consider a solution like rePORTAL. This is a web application that allows you to publish, manage and schedule both Crystal and SQL Server Reporting Services reports quickly and easily without any coding. You can schedule to email, printers, SharePoint, ftp, web sites and more. It even includes bursting and packaging capabilities and you don't need to buy any SQL Server or Reporting Services licenses.

richykong SSCommitted Points: 1502 More actions · Answer 5

The most straight forward way would be to create 12 schedules.

Schedule 1

Daily: Monday,Tuesday

Start 6:00 AM

Schedule 2

Daily: Monday,Tuesday

Start 7:00 AM

...

Or you could try to manipulate the schedule for the SQL job. When you create a scheduled report, it creates a SQL Job that triggers the report. Find the specific SQL job and update the schedule to Recurring > Weekly > Mon, Tue > Occurs every: 1 Hour > Starting at 6:00 AM > Ending at 6:00 PM.

Chris Ells Valued Member Points: 74 More actions · Answer 6

Unfortunately, that link doesn't explain even how to create a subscription.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 7

Chris Ells (11/25/2014)
Unfortunately, that link doesn't explain even how to create a subscription.

Maybe this link is better.

http://lmgtfy.com/?q=how+to+schedule+ssrs+report+for+emailing

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]