BusinessObjects Board

Can I get the SQL Query for getting BCA reports information?

scheduling Broadcast Agent (BCA)
#1

Hi

Can you help me in getting the query which gives information like BCA agent name,Reports scheduled according to user,and the scheduled information,status from the Oracle Repository?

Thanks in Advance.

vamsi krishna (BOB member since 2005-11-18)

Report on tasks running in BCA 5.1.2
#2

There is one key database table for this called DS_PENDING_JOB. Search this forum, if you don’t find a whole load of different queries against this table I’ll be surprised :wink:

Nick Daniels :uk: (BOB member since 2002-08-15)

#3

if you have auditor products, the auditor univers can provides you also enhanced informations about this
regards
bernard

bernard timbal :fr: (BOB member since 2003-05-26)

#4

Have a look also at the BOB’s download section. You can find there:

  1. 6.5.1 Repository universe for User/Group/Document & BCA
  2. BCA Auditing and Reporting

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

#5

How do I open this universe as I am getting an error “you are not authorized to use this universe”?

Thanks for your reply.

vamsi krishna (BOB member since 2005-11-18)