Skip to Content
0
Former Member
Oct 05, 2010 at 11:28 AM

Retrieve report status using query

30 Views

Hi all,

I ve a java program to call the BO java SDK to generate crystal report in BO server. To ensure the report has been generate successfully, I ve a query to retrieve the job status ti check whether the report is fail or not.

However, I discovered the query is getting slower these weeks and it takes 1-2 mins to return the result, anyone can help to check? Do I need to house keep the table CI_INFOOBJECTS ? But I can't find this physical table in the BO table.

Select SI_INSTANCE, SI_SCHEDULE_STATUS, SI_NAME

From CI_INFOOBJECTS

Where SI_INSTANCE_OBJECT=1 AND SI_NEW_JOB_ID=xxxx

Thank you in advanced.

Grace