How to identify scheduled reports that don't run?

239 views Asked by At

We are running Cognos 11.0.1. There are times when scheduled reports don't run. This is an intermittent problem. I'd like to know if there is a way to identify these schedule reports that fail to run.

1

There are 1 answers

5
dougp On

This will show you all of the failures in the last 24 hours, when a report, dataset, agent, etc. was run, scheduled or interactive. So, not exactly what you need, but it get you closer.

IBM Cognos Administration
Status
Past Activities
Period = Last 24 hours
Status = Failed

You can set Type if you want to see one, specific type of object. Oddly, dataset is not an option.

If you have configured Cognos to audit to a database, you can also run a report against the Audit database. COGIPF_RUNREPORT will likely get you most of what you want (reports, datasets, report views), but for [far more detail than you ever wanted] you should take a look at COGIPF_ACTION. If you go this route, you should be able to combine the Audit results with results from a Content Store query that identifies which objects are scheduled.