Improve administration of Scheduled Reports

We have a CA enterprise system that has been live for over 15+ years.

Over that time users have created hundred of schedules. Some of those schedules are on reports they have created themselves or report views.

Some of those schedules error because either their report has become broken, or the report view is no longer valid.

There is no easy way of cleaning up hundreds bad schedules. Basically, we have a lot of reports scheduled that will never work and there is no easy way of removing this noise from the system.

These invalid schedules just take away from system resource that could be used for valid reports.

My idea is for a admin controlled report sin bin.

The system administrator should be able to set a sin bin limit. If a schedule fails consecutively for the sin bin limit then the schedule is disabled.

The administrator should easily be able to see reports in the sin bin. Within the sin bin view we should easily be able to filter a time range and see how many attempted runs were made of the schedule in that time range, how many succeeded and how many failed.

For example, in the last 6 months I can see a report attempted to run 180 times and 180 failed. Or in the last 6 months I can see a report attempted to run 180 times and failed 5 times.

Within the Sin Bin view I should be able to delete a report, reset the sin bin count, remove from the Sin Bin.

If a report schedule has an email output set up, then when a report is moved to the sin bin the email contacts should be used to send a warning that the report schedule has been suspended and to contact the Cognos Admin to reinstate if the report is still needed.

The email could include a link that the recipient clicks on.

Within the sin bin view, reports that have been requested to be reinstated would be flagged as such for the administrator to take action.

Within Cognos portal, objects placed in the sin bin would show this on their schedule page. Going to the schedule tab would say report disabled, click to request re-enable and again the admin could take action from the sin bin view.