COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => SDK => Topic started by: Scott K. on 16 Mar 2010 04:01:01 PM

Title: Checking Report / Job status outside of SDK
Post by: Scott K. on 16 Mar 2010 04:01:01 PM
I'm looking for a better way to check a job status.  I have a macro that checks the audit database for the entries and the success status.  However, that has its occasional issues because entries do not always get into the audit db quickly.  Is there another way to do this?  Can I access the content store somehow using VB script?
Title: Re: Checking Report / Job status outside of SDK
Post by: xiska on 12 Jun 2010 04:39:17 AM
Hi

Of course you can connect to a database with odbc and query it. I would not do this - do not write or lock the db.
With some tools Quest on db2 you can view the latest sql statements which will help you to find the right table.
In case of derby I cannot say how to do that.
Take a look at the kb at ibm - there are many questions and answers for this problem.

Have Fun