who can tell me how to get webi report schedul's status

[system]

Hi ,

I have some reports , and need set scheduler on erery reports .
Now, i scheduled all the reports , and set the reports recivers are my customer and me , so i will know which report’s schedul’s status is success and which is failed. and this let my infobox full.
now i want to do some sdk code , who can tell me how to get the report instance’s status? i selected from CI_INFOOBJECTS,CI_APPOBJECTS ,CI_SYSTEMOBJECTS , and can’t find anything about report’s schedul instance in the three tables .
help me .thank you very much

---

lishuanggen (BOB member since 2007-03-16)

[system]

Did you not check the instance manager from admin launchpad?
It has options to see which all reports run by a user and their status

.

---

haider (BOB member since 2005-07-18)

[system]

Check XIR2 scheduling instances viewer on BOB’s downloads.

XIR2 scheduling instances viewer

Author: Rachidb Author notes: This macro generates information about instances finished/running/pending. It accepts a date range. If start date is omitted it shows instances statuses for a given day starting 12AM until time of run. End date is also option and will default to current date/time. Rows returned is limited to 64000 rows. But please be careful not to run for a big date range as it may overload your CMS. Platform: Excel 2003 Version: Initial release 1.0 Feel free to give feedback …

Rachid

---

rachidb (BOB member since 2006-07-06)

[system]

Here is a sample from the DevLibrary:
http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/en/BOE_SDK/boesdk_java_dg_doc/doc/boesdk_java_dg/SampleCode13.html#347703

---

darcstorm (BOB member since 2008-07-22)

[system]

Follow Rachid suggestions, if you want a DIY select, here it is

"SELECT SI_SCHEDULE_STATUS FROM CI_INFOOBJECTS WHERE SI_ID = "

---

Federico.Garagiola (BOB member since 2009-02-24)