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

Sameer.Darbha

Summary

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

Content

Hi

 

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

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