How to schedule SSRS Report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » How to schedule SSRS Report

How to schedule SSRS Report

Rate Topic

Display Mode

Topic Options

Author

Message

Ganesh Lohani

Posted Thursday, October 15, 2009 2:12 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, April 26, 2013 12:23 PM
Points: 883, Visits: 1,661

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.

Post #803747

Elliott Whitlow

Posted Thursday, October 15, 2009 2:38 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

Post #803763

Ganesh Lohani

Posted Thursday, October 15, 2009 2:54 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, April 26, 2013 12:23 PM
Points: 883, Visits: 1,661

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

Thanks

Post #803777

Elliott Whitlow

Posted Thursday, October 15, 2009 3:00 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

CEWII

Post #803792

David Smithson

Posted Friday, January 18, 2013 5:07 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 18, 2013 5:04 PM
Points: 3, Visits: 5

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.

Post #1409136

richykong

Posted Thursday, January 31, 2013 3:02 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:26 PM
Points: 127, Visits: 436

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.

Post #1414367

« Prev Topic | Next Topic »

Permissions