I want to create a report that looks like the "Past Activities" portal in Cognos Administration. From there I want to set up a schedule to check for any failed schedules. I have been able to see some of what I am looking for in the Audit tables but have yet to get exactly what I am looking for. In addition to seeing the failed schedule I want to see the "view run history details" that I see when I am in Cognos Administration.
Has anyone every done this? Is this even possible? If so please share what you can.
To Recap: If I click on Past Activities and then narrow my search to "Failed" I get the view I am looking for but then I also want the error message from view run history details.