Link to home
Start Free TrialLog in
Avatar of lcallah93
lcallah93Flag for United States of America

asked on

Crystal Server Report Instances

Hello experts -

I am looking for an easy way (famous last words, I know) to skip daily instances in Crystal Server 2008.  We have over 1,600 daily recurring instances and two nights ago a tech had to stop the CMS because a Crystal report locked all the database tables.  I have restarted the CMS, but now all the instances are running in chronological order, starting where it left off two nights ago.

UGH.

I would like to just stop all the pending instances for all recurring reports and have them start up fresh tonight but I don't see any way to do that easily.  I have tried to search the instance manager for pending reports but they are not listed as pending until they are queued up to run.  If I delete all the recurring instances then I will need to re-create all 1,600 recurring instances all over again.

Am I missing something?

Help!!

Lisa
Avatar of Mike McCracken
Mike McCracken

I don't think you are missing anything.

I am not aware of a way to do what you want.

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of LinInDenver
LinInDenver
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lcallah93

ASKER

That is a great idea with the ODBC connection.  I ended letting them run and all is well, but I will keep that in my toolbox (I have a feeling it will happen again....)

Thank you and happy new year!!