OBIEE 12c - How to schedule Agent in LOOP

Question

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 ?

[Deleted User] · Answer

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,...