List all scheduled reports

vai

Summary

List all scheduled reports

Content

We have a lot of reports scheduled from BI publisher mostly to email destinations.

I want to extract a list of all the reports scheduled with BI publisher along with the recipient list.

How can i do this?

 

Thanks,

Vaibhav

Violeta F

Hi,

You can try using the webservices to retrieve the scheduled jobs and their parameters. Please check:

Oracle BI Publisher Web Services APIs - Common Use Case Examples (Doc ID 1344535.1)

Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also benefit from it.

Regards,

Violeta

Dragos Hristache

Hi,

These are all BIP scheduler tables:

QRTZ_BLOB_TRIGGERS
QRTZ_CALENDARS
QRTZ_CRON_TRIGGERS
QRTZ_FIRED_TRIGGERS
QRTZ_JOB_DETAILS
QRTZ_JOB_LISTENERS
QRTZ_LOCKS
QRTZ_PAUSED_TRIGGER_GRPS
QRTZ_SCHEDULER_STATE
QRTZ_SIMPLE_TRIGGERS
QRTZ_TRIGGERS
QRTZ_TRIGGER_LISTENERS
XMLP_APPINFO	Only 11g
XMLP_SCHED_DATA	Only 11g
XMLP_SCHED_DELIVERY	Only 11g
XMLP_SCHED_JOB
XMLP_SCHED_OUTPUT
XMLP_SCHED_SUBSCRIPTION	Only 10g

You may create a query on XMLP_SCHED_JOB to get the required information.

Thanks,

Dragos

Dhruvjoshi23

Vaibhav-  did you get any resolution for this ? 

Abhiengine

Hi All,

Anyone has got solution for this?

Andrew_Schmitz

This is a helpful link:

https://community.oracle.com/customerconnect/discussion/552872/table-for-ess-job-schedule

There is also a sample query in another comment in that link ^

fusion_ora_ess.request_property

fusion_ora_ess.request_history