COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: captain karisma on 15 Dec 2009 05:44:55 AM

Title: Removing failed scheduled reports
Post by: captain karisma on 15 Dec 2009 05:44:55 AM
Hi guys,

Is there an easy way to purge all the failed reports that are in the schedule management?
They are starting to clutter up

Thansk for any advice
Title: Re: Removing failed scheduled reports
Post by: cpalone on 21 Apr 2011 08:10:54 AM
Hello:

Did you ever find a solution for this issue?  We are having the same issue (failed reports piling up) and did some searching and came upon this post.

Please let me know.

Thanks!

Connie
Title: Re: Removing failed scheduled reports
Post by: michal on 11 May 2011 12:26:35 PM
we are also having same problem....

i tried to get this through support lines at ibm
- there are no sql scripts that are currently available from ibm (or anywhere, really) to do this
- have made an 'enhancement request' for this

we also have some 'unknown' schedules (which cannot be removed seemingly) - ill be testing some hand written sql scripts soon :)
Title: Re: Removing failed scheduled reports
Post by: Sheldon on 11 May 2011 02:00:37 PM
Where you said "we also have some 'unknown' schedules ", do you mean that there are jobs running on a regular schedule but you are not able to find any information about them such as who scheduled them, how to stop them, etc.?

Sheldon