Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c - How to schedule Agent in LOOP

Received Response
11
Views
1
Comments
Avinash Pentyala
Avinash Pentyala Rank 5 - Community Champion
edited August 2024 in Oracle Analytics Cloud and Server

Dears, I have a requirement to trigger agents in LOOP based on data loading. I create a agent schedule 8AM but some ETL loads got delayed due source files. I added a condition in to check ROW COUNT and triggering the agent. But if loads completed by 9 Am I want trigger agent without running Manuval? Please let me know how to archive this ?

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    a) Have the ETL call the Agent. Most ETL tools are capable of that and it's a lot more clever than option B.

    b) Run the Agent every hour with a condition which checks whether there is anything to do.

    Push / event-driven is always a lot better than constant pull / polling, polling, polling, polling, polling,...