SQL to query current BI Agents scheduled to e-mail / dashboard page etc
Summary: I have written an sql query to extract all BIP reports currently scheduled, but want to do the equivalent with OTBI BI Agents - is it possible using sql and access to the tables / views in Fusion Financials?
Content (required): Using BI Publisher I want to develop a report to query the BI Agents that are currently live and running against OTBI subject areas, can anyone tell me if this is possible and if so give me a pointer as to which database tables I need to utilise for this purpose?
Thanks for any pointers.
Version (include the version you are using, if applicable):