Report Status 'Running' For 24+ Hours

Hello

Yesterday there were two reports scheduled to run and email at the same time. One of these ran successfully but the other is still in a Status of ‘Running’. Job Failure notifications are set but as it didn’t fail no messages were sent.

To get the report out I right clicked this Instance and chose ‘Run Now’. The report ran in 24 seconds and emailed successfully. The report is set up to run weekly Mon-Thurs at 2.30pm. This particular Instance has an Expiry of 14/7/11 2.30pm so I decided to see what would happen. It is now after this expiry time and the instance is still there with the Status of Running.

I also asked the DBA’s if the SQL had been sent on 13/7/11 at 2.30pm but it hadn’t.

  1. Why would it remain in this status?

  2. Why has it not expired?

  3. Best way to be notified something is wrong (The report has been running for two months with no problems).

We are on version:

Crystal Reports 2008 (12.1.0.892). Crystal Reports Server 2008 (12.1.0)

And have set:

Max Concurrent Jobs = 10 on each Job Server


BenR (BOB member since 2011-04-20)