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

extract List of All the Scheduled Reports

Started by BHADX001, 10 Jun 2010 09:38:44 PM

Previous topic - Next topic

BHADX001

Hi,
Is there any way to extract List of All the Scheduled Reports including the Email ID's and Time they are scheduled for with Delivery Format without looking at schedule information for each and every report.This
wouldbe for Cognos 8.3??

makoah

I don't think this is possible, have been searching and trying numerous ways.

I did come up with this script to list to list the scheduled jobs:
select
n.cmid
, n.name
, o.pcmid
, o.created
, c.classid
, c.name stype
, o.owner
from cogrepuser.cmobjnames n
, cogrepuser.cmobjects o
, cogrepuser.cmclasses c
, view_of_cgn_objects ob
where n.cmid = o.cmid
and o.cmid = ob.pcmid
and o.classid = c.classid
and n.isdefault = 1
and n.mapdlocaleid = 148 -- > Dutch language, you may need to change this
and ob.classid = 39   --> class id of scheduled jobs

The result of these jobs do not seem to show in reports made in the Audit package.

Anyone who did manage to work this out, please share !