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

Reporting Services: Please help Expand / Collapse
Author
Message
Posted Friday, June 21, 2013 2:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 20, 2014 10:38 AM
Points: 17, Visits: 34
Hi I have a report that runs hourly but now i have to reduce the time it runs from 12 am to 6pm and it mus not run on weekends how do i go about doing that?
Post #1466085
Posted Thursday, June 27, 2013 5:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 2,449, Visits: 2,992
Change the current schedule to match the execution times the reports needs to run. Create multiple schedules if you won't be able to solve it with just one schedule.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1468085
Posted Thursday, June 27, 2013 6:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 12:10 PM
Points: 10, Visits: 84
This should help you start Report Manager:
http://msdn.microsoft.com/en-us/library/ms156496%28v=sql.90%29.aspx

And this should help you do what you need to do:
http://www.sqlservercentral.com/articles/Stairway+Series/72654/
Post #1468403
Posted Thursday, June 27, 2013 6:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 12:10 PM
Points: 10, Visits: 84
This video might help, too.

http://technet.microsoft.com/en-us/sqlserver/dd420576.aspx
Post #1468404
Posted Friday, June 28, 2013 2:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 20, 2014 10:38 AM
Points: 17, Visits: 34
Thank you
Post #1468461
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse