COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Content Explorer - Portal => Topic started by: chrispie on 27 Aug 2021 10:09:13 AM

Title: Get Details from the Content Store Regarding Schedules
Post by: chrispie on 27 Aug 2021 10:09:13 AM
Hi there,
I really hope you can assist. I need to create a Cognos report providing details of all schedules and containing the following information:
Schedule Name
Schedule Path
Step Name
Step Path
Schedule Type (report, job, etc)
Schedule Status
Schedule Owner
Next Run Date
Last Run Date
Last Run Duration

I am having trouble finding the Last Run Duration and I can't use the Audit database because it doesn't seem to contain all the information that I need

Thanks very much in advance
Regards,
Chrispie