COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: collierd on 30 Jul 2009 04:14:54 AM

Title: List of schedules
Post by: collierd on 30 Jul 2009 04:14:54 AM
Hello

Using Cognos 8.2

I've spent a fair bit of time searching forums, google etc. and can't seem to find a solution

We have over 600 schedules and this is increasing
Is there an easy way to list all the schedules in existence with a little bit of detail (who created, time it runs etc.)
Looking at Tools -> Schedule Management, I can find some detail but it's not particularly helpful

Presumably this is all stored in the Content Manager database (SQL Server)   [I think??]
Either, is there an easier way through Cognos Connection or does anybody know the tables this data is held in

Thanks for any help

Title: Re: List of schedules
Post by: cogknowhow on 02 Aug 2009 10:49:33 AM
hi

is the table CMOBJPROPS2 what you are looking for?

CMOBJPROPS2   Report scheduling information is stored. This table has fields like hour, day week etc   

good luck!