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??
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 !