Hi All,
i have configured a notification store database in the cognos configuration. the tables created in the database hold the information related to the schedules in cognos coneection.
can anyone help me to track the table name which holds the information for the status of the scheduled reports, for example i want to track down reports which have failed during execution.
thanks in advance.
Regards
Hi there
I ran this type of query against the Audit database
SELECT *
FROM COGIPF_USERLOGON,
COGIPF_RUNREPORT
WHERE COGIPF_RUNREPORT.COGIPF_SESSIONID = COGIPF_USERLOGON.COGIPF_SESSIONID
AND COGIPF_RUNREPORT.COGIPF_SESSIONID = COGIPF_USERLOGON.COGIPF_SESSIONID
This should be modified with a data range like
***Oracle Syntax where you can change 0 for any number of days prior to current.
TRUNC (COGIPF_RUNREPORT.COGIPF_LOCALTIMESTAMP) BETWEEN TRUNC (
SYSDATE
- 0)
AND TRUNC (
SYSDATE)
There are other means but see what you think
Cheers
AussiePete