COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: ambatiuday on 17 Jul 2012 03:19:01 PM

Title: Cognos Pending Jobs- Content Store- Version 8.3
Post by: ambatiuday on 17 Jul 2012 03:19:01 PM
Hell Guru's

I want to  create a report to know the status of the Pending Jobs.I know you first thought would be audit database reports but for audit db in run jobs query subject we have only 2 statuses for job  query item ( either success or failure).  I am try to achieve this from content store table using a sql. One more thing I want to mention that we don't have license  to use SDK so that solution is ruled out.

The  main reason for the requirement is whenever we have  greater then 20 jobs in pending status  then we need to get notified  regarding the status. This helps us to take an action immediately.

Please let me know if anyone has a solution. Thanks in advance

Regards
Coguser
Title: Re: Cognos Pending Jobs- Content Store- Version 8.3
Post by: Rahul Ganguli on 18 Jul 2012 06:10:38 AM
You can directly see this in Cognos Administration.
Also, you can see some tools from BSP, Control-M from BMC.

I will see if  I can find something from content store directly.

Regards,
Rahul