List of all scheduled reports

scheduling XI Scheduler
1

Is there a way to get the list of all scheduled reports in BOEXI R2?

franklopes (BOB member since 2006-01-20)

2

If you log in to InfoView as Administrator you should be able to view all Scheduled objects.

Hope that helps :smiley:

cartwrightjepson :uk: (BOB member since 2005-10-18)

3

I’m looking at infoview and I have admin rights.
There are many folders some of them have scheduled reports, others have on-demand reports.

Where do you see the list of all “scheduled” reports?

franklopes (BOB member since 2006-01-20)

4

If you go to the launchpad, on the left hand side is a section of links titled “Administrative Tools”. Either Schedule manager or Instance manager may help to give the information you are looking for. I’m not sure either will give a complete list, but using Instance Manager, if you search for “Recurring” instances, and then leave the user name blank it will return a list of all instances, regardless of which user shceduled the object.

:slight_smile:

mizooki (BOB member since 2006-01-26)

5

Hi,

Indeed you need to use SDK to know this !!

Regards

6

I’m afraid I have never touched the SDK…Maybe we are talking at cross purposes…I have attatched a screen shot.

I thought these were installed as part of the standard installation in both the .net and Java environments. They always have been on my installations anyway…

:slight_smile:
Launchpad picture.doc (102.0 KB)

mizooki (BOB member since 2006-01-26)

7

Essentially, the Administration Launchpad is a set of basic tools that was built by BusObj using the SDK. Those tools are useful of course, but they are also a sort of SDK demo as well.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

8

This doesn’t require any fancy programming using the SDK, though. Just take a look at Administration Tools like Mizooki mentioned.

While at the administration launch pad, on the left there is the section called “Administration Tools.” Choose the “Instance Manager.” After logging in, you’ll get a search box. Choose “Recurring” from the list and leave user blank. Click Go, and viola, your requested list appears, no programming required.

If you’re apt to try the programming approach, play with the query builder, we’ve found it to be really useful when trying to get instance info quickly.

sartorij (BOB member since 2006-03-07)

9

I have used Instance Manager to see the list of Scheduled tasks. But as an Administrator, you can only VIEW the tasks. You cannot see their properties nor modify them with Instance Manager.

You can see and change properties with Infoview, but you need to know what folders these scheduled task reside in.

So I tried to use Schedule Manager. What I find is that my Crystal Reports show up (you need to know the report object’s folder) but the WebI scheduled reports do not appear in the list.

Have others found this to be the case? There does not seem to be a convenient method for an Administrator to see/change/monitor the scheduled tasks created by their users.

Irwin Miller :us: (BOB member since 2002-08-16)

10

I am sorry to ask a stupid question… SDK means Business viewer???what is the module to operate this SDK??

Regards,
R

venira :india: (BOB member since 2004-12-07)

11

In general terms an SDK is the Software Development Kit. It is a way to develop applications to use hooks into an application (in this case Business Objects) to perform functions that otherwise would have to be done manually.

sartorij (BOB member since 2006-03-07)

12

Hi all,

Does anyone know how to create a report showing what reports are scheduled and their run times in XI R2? I used to be able to do it in CE 9 but the columns I was using are now binary and don’t work w/ a normal query. The Instance Manager will work for the time being but I’d like to have a report in InfoView so users could run it to see what times are free for scheduling.

Thanks much,

-Gerry

GerryD (BOB member since 2006-03-27)

13

I can’t see WebI or DeskI reports in the Schedule Manager either.

MAKM :us: (BOB member since 2006-06-07)

14

Hi
We have just come for BO 5 where we had BCA running. Here you could list all the schedulled jobs and ammend their schedulling if required. Is there anyway for doing this in XI. we have many reports that all refresh in a 24 hour period so need to space them out to stop the system being overloaded. Everything in XI appears to require you to know a report name so you can then locate it and change the schedulling that way.
Does anyone know where is the schedulling data held in XI ?
Regards
Melo

Melo (BOB member since 2004-02-26)

15

Within Infoview, try using Categories, which can be set for a report from its Properties link.

You can set multiple categories for a scheduled document such as frequency, department, etc.

Then you can quickly see the list of reports by switching from folder view to category view in the Navigation Panel.

Irwin Miller :us: (BOB member since 2002-08-16)

16

I think what you might be interested in is querying the InfoObjects. All objects are in the CMS repository and all reports are objects. Scheduled reports have Schedule Propertires. When you go to the adminlaunch go to the query builder. Queries are written in a quasi-sql language (since the DB Repository is mostly binaries). I have finally been able to create a query to find al lthe failed reports for the day. I created this code by looking through the SDK documents and a lot of testing. The samples given are very basic and it doesn’t seem to be well documented.

If you are stuck let me know. I am building a bag of “tricks” for the infoObjects SQL.

cduey :us: (BOB member since 2002-09-05)

17

Hi Clark

Can you post some of your SQL?

I am certain others (including myself) could benefit from seeing it.

Thanks
Irwin

Irwin Miller :us: (BOB member since 2002-08-16)

18

Hello,
Could you tell me how to get the SDK?

Thanks.

ceoj (BOB member since 2006-03-27)

19

I use the following to find all Failed Schedules. Change the date as needed. I run this from http://:/businessobjects/enterprise11/adminlaunch/query/ie.jsp

select SI_NAME, SI_OWNER, SI_AUTHOR, SI_STATUSINFO from CI_INFOOBJECTS where SI_SCHEDULEINFO.SI_OUTCOME>=2 and SI_SCHEDULEINFO.SI_STARTTIME>=‘2006-06-02’

cduey :us: (BOB member since 2002-09-05)

20

Hi
Yes your code is good for failed jobs but have you attemped to interegate these tables to locate when each sceduled report will run next ? I am sure it must be posible. I expect to have bottlenecks but it appears unless I record off system when each report is due to run I will not know.
Any help appreciated
Melo

Melo (BOB member since 2004-02-26)