Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...A lot of the information I've found at this site would've taken me forever if I'd have attempted to research it on my own. Thanks again."

Geography

Where in the world do Tek-Tips members come from?

Crystal Reports Server - Only allow reports to run off hours?

fmrock (Programmer)
3 May 12 9:47
I have a set of crystal reports that are hitting a production database, and they seem to be causing some performance issues to that production system.  Is there way in Crystal Reports Server 2008 to limit a report so it can only be run during off hours?  say 6pm-6am?
briangriffin (Programmer)
3 May 12 12:18

So you only want to restrict specific reports, not all reports, right? The short answer is not really.

You can create a new job server and put it into a server group. Then in the CMC restrict those reports to only use that server group. But you would have to manually diable/enable that job server each day.

You could also create an additional SIA which only holds the new job server, and find a third party tool that can stop and start the SIA service at specified times. I don't know of a tool to do that offhand, but I'm sure there is something out there. If you go that route and find something that works please post it here.





 

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close