Oracle Analytics and AI

Can we get 'Report Job Id' from Scheduler, In After Data Trigger in Data Model ?

Summary

Can we get 'Report Job Id' from Scheduler, In After Data Trigger in Data Model ?

Content

OBIEE/BIP 12.2.1.3

I have a Report Definition with a Data Model Defined in the Catalog
In the Data Model, I created a After Data Trigger to point to a PLSQL Function in a Package.

Now, I want to schedule this Report using the Scheduler (Default BIP Scheduler)
When I schedule this Report, it will generate a unique 'Report Job Id'.

My Question is when this Report is being executed, is there a way for me to get the 'Report Job Id' in the PLSQL Package Function ?
Or can I pass it as a parameter like :REPORT_JOB_ID in the After Data Trigger setting ?

(I am assuming that the Report Job Id is generated by the scheduler first and the Report will start getting executed later)

Thanks for any help
Sameer

Find more posts tagged with

Reporting

Packaging and Licensing

Accepted answers

All comments

YGUTTIKONDA

Sameer,

I assume YES, try the following in your trigger query the JOB_ID from the scheduler table as below ..

SELECT JOB_ID,STATUS

FROM XMLP_SCHED_JOB

WHERE USER_JOB_NAME ='JOB_NAME'

Hope this helps

Yugandhar