Hello
This is with regard to Business Objects 6.5. Database is Oracle. I want to get a list of all the scheduled reports with distribution list for each report. How can I do this without going through each report manually?
When I do " Console/ export to ", I do get all stats of scheduled reports except the distribution list for each report.
Please advise
Frank
frank_tyson (BOB member since 2007-05-31)
Boy, this is going back a ways.
Scheduled jobs (pending and processed) are stored in ds_pending_job.
I think the recipients are stored in ds_user_list. ds_pending_job.document_id = ds_user_list.document_id and ds_user_list.user_id = obj_m_actor.m_actor_n_id (obj_m_actor contains all users)
joepeters 
(BOB member since 2002-08-29)
I found this topic – there’s a handy script on page 1 that will get the info you’re looking for.
Joe
joepeters (BOB member since 2002-08-29)