How to report failed jobs/tasks against the audit store database

[Stephane Lambert]

Hi,

I'm trying to report failed jobs/tasks against the audit store DB (tables: COGIPF_RUNJOB & COGIPF_RUNJOBSTEP) but all entries have the status field set to "SUCCESS" or "BLANK" even if my task has failed.

If I try same thing on the run report table (COGIPF_RUNREPORT), proper failed status has been applyed to DB entries.

Any clue on how I can report this on tasks/jobs ?

Thanks.

[Vivekmore23]

Hi Stephane

Have you tried checking out the Audit Setting in Cognos Administration?

go to Administration --> Configuration --> Dispatcher and Services

Click on Set Properties for Dispatcher.  Under Settings Tab, Select only Logging Category.

check out the status of logging level for agent service,logging level for job service and logging level for batch report service. don't set it to FULL or trace. a lot of data would be generated. i am not sure which one of the above setting would do the trick  ;)

By the way which Cognos version are you running this for?

Regards
Vivek M

[Vivekmore23]

Hi Stephane,

before you try my previous option, try this.

Use the table COGIPF_RUNREPORT but use it with the following filter

COGIPF_TARGET_TYPEin ('Report batchreportservice') .

Basically use the Query subject "Run Reports" from the Audit package and filter Report Type by 'Report batchreportservice' to give you only job related reports.

Thanks
Vivek M