BusinessObjects Board

How to retrieve scheduled report's information in BO-6.x?

How to get reports that are scheduled using BCA in BO-6.x versions? Is there any macro code available to achieve this?

Regards,
Bhuvan R


Bhuvan (BOB member since 2008-12-02)

What information are you looking for? Scheduling info or the report itself?

Joe


joepeters :us: (BOB member since 2002-08-29)

I want to know the scheduled reports, the time of schedule, the status of the scheduled reports…


Bhuvan (BOB member since 2008-12-02)

Hi,

All this information is in DS_PENDING_JOB table in the BO repository.

The description of this table can be found here:

The description is for BO repository 5.x but this table did not change in BO 6.x so it is (or should be) valid for your table as well.

And have also look at these 2 universes in the BOB’s Downloads section:
BCA Auditing and Reporting
6.5.1 Repository universe for User/Group/Document & BCA


Marek Chladny :slovakia: (BOB member since 2003-11-27)

It really helped me.Thanks a lot for your information!


Bhuvan (BOB member since 2008-12-02)