Oracle Analytics Cloud and Server

Products Banner

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

Received Response
34
Views
1
Comments

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

Answers

  • YGUTTIKONDA
    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