We have a server runs every week a schedule to generate 10 reports at the
same time. It usually runs in one hour (all reports).
But now the CPU hungs at 100% for two hours (ReportServer.exe) and none of
the reports are generated.
We stopped IIS and the ReportServer several times, but something keeps
re-scheduling all 10 reports and it gets hung up again.
Can somebody tell me how to delete the self-scheduled jobs?
Thanks.You are not alone... I got the same issue and had to uninstall then
re-install the SQL Reporting Services (oops! not the best way).
"Cesar Meza" wrote:
> We have a server runs every week a schedule to generate 10 reports at the
> same time. It usually runs in one hour (all reports).
> But now the CPU hungs at 100% for two hours (ReportServer.exe) and none of
> the reports are generated.
> We stopped IIS and the ReportServer several times, but something keeps
> re-scheduling all 10 reports and it gets hung up again.
> Can somebody tell me how to delete the self-scheduled jobs?
> Thanks.|||I gave up, so this is what I did:
1. Stop both IIS and ReportServer
2. Deleted manually all the entries from the table Schedules, RunningJobs
and Subscriptions.
3. Re-start all services, and delete any entries (if any) in the schedules
and subscriptions via the Report Manager.
4. Re-schedule the job.
Note of caution: I only had one schedule with 10 jobs on this server, so it
was a no brainer. I DO NOT RECOMEND doing this if you have several schedules.
If you have to, delete only the entries needed.
If somebody from the gurus have an explanation for this, or have better way
to do what I did, please share it with us.
Thank you.
"dontra" wrote:
> You are not alone... I got the same issue and had to uninstall then
> re-install the SQL Reporting Services (oops! not the best way).
>
