hello!
I am developing a system that uses APEX Automations instead of standard schedulers.
I have a need with SQL to retrieve a list of tasks in automation, the list on is in a table in schema APEX_210100.WWV_FLOW_AUTOMATIONS.APEX Automations api does not include such function, so I need to fetch from this table. My question is if I need to do select * from APEX_210100.WWV_FLOW_AUTOMATIONS then I need to:
1. have permissions to this table
2. after updating APEX system will stop working (rename schema - if table/view remains)
Any ideas how best to do this?
regards