Provide access to BI Publisher XML scheduler tables

Sudhesh Nayak

Description

This functionality is not currently available in Cloud/SaaS environments. Support has raised the below Enhancement Request (ER 22590867) for this capability.

 

Need access to the following tables under fusion_biplatform schema

• 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_TRIGGER_LISTENERS
• QRTZ_TRIGGERS
• SEQUENCE
• XMLP_APPINFO
• XMLP_SCHED_DATA
• XMLP_SCHED_DELIVERY
• XMLP_SCHED_JOB
• XMLP_SCHED_OUTPUT

 

 

Access would allow us to better report on failed jobs and to identify the status of extracts

Use Case and Business Need

Access to these would allow us to better report on failed jobs and to identify the status of extracts

Original Idea Number: 99d4940ab4