Oracle Business Intelligence 12.2.1.3.0 Make a smart Agent

Hello all, i am using Oracle Business Intelligence 12.2.1.3.0.

I need help with the following topic.

In our project when we use data from our Warehouse in our OBIEE Reports and Dashboards, we have Agents that send Reports with different frequency.

I need to develop a logic that determines if the ETL for the day is finished. And if it is finished, to trigger the Agents to send the reports.

I was thinking to create a condition - based Agent which will use the content of one Analysis that will contain a flag true when the ETL will be finished. And if ETL is not finished, it will be empty, so the check row count of Analysis will return false.