If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

List of schedules

Started by collierd, 30 Jul 2009 04:14:54 AM

Previous topic - Next topic

collierd

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


cogknowhow

#1
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!