Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

List all scheduled reports

Received Response
972
Views
5
Comments
vai
vai Rank 4 - Community Specialist
edited Feb 28, 2024 9:58AM in Oracle Analytics Publisher

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

Tagged:

Answers

  • Violeta F
    Violeta F Rank 4 - Community Specialist

    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
    Dragos Hristache Rank 1 - Community Starter

    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_APPINFOOnly 11g
    XMLP_SCHED_DATAOnly 11g
    XMLP_SCHED_DELIVERYOnly 11g
    XMLP_SCHED_JOB
    XMLP_SCHED_OUTPUT
    XMLP_SCHED_SUBSCRIPTIONOnly 10g

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

    Thanks,

    Dragos

  • Dhruvjoshi23
    Dhruvjoshi23 Rank 2 - Community Beginner

    Vaibhav-  did you get any resolution for this ? 

  • Abhiengine
    Abhiengine Rank 2 - Community Beginner

    Hi All,


    Anyone has got solution for this?

  • Andrew_Schmitz
    Andrew_Schmitz Rank 5 - Community Champion

    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