Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to schedule SSRS Report Expand / Collapse
Author
Message
Posted Thursday, October 15, 2009 2:12 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 14, 2014 1:03 PM
Points: 888, Visits: 1,730
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
Posted Thursday, October 15, 2009 2:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
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
Posted Thursday, October 15, 2009 2:54 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 14, 2014 1:03 PM
Points: 888, Visits: 1,730
Please elaborate your idea. I need to set up it for next week.

Thanks
Post #803777
Posted Thursday, October 15, 2009 3:00 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
Start here:
http://msdn.microsoft.com/en-us/library/ms159271(SQL.90).aspx

CEWII
Post #803792
Posted Friday, January 18, 2013 5:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 23, 2013 2:45 PM
Points: 3, Visits: 6
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.
Post #1409136
Posted Thursday, January 31, 2013 3:02 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 14, 2014 9:39 AM
Points: 132, Visits: 579
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 »

Add to briefcase

Permissions Expand / Collapse