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