Skip to Main Content
Feature Request FR-3162
Product Area APIs
Status ROADMAP

12 Voters

Ability to track progress of running Automation

haniel b. Public · May 23 2023

Idea Summary
Currently, it's only possible to determine if an Automation is running, but not much else. It would be nice to have built-in support for tracking an Automation's progress. This would mainly apply to Automations with a Query source type. A general improvement would be if the Automation logging procedures where autonomous so the execution log could be queried in real-time. 

Use Case
Display a progress bar in the UI, or report of all running Automations with a status or completion percentage. 

Preferred Solution (Optional)
 

Some ideas, these could be used independently to track progress. 

  1. Add a new bind variable for total row count, like APEX$AUTOMATION_ROW_COUNT that holds the total row count selected in the Query source. (For performance this would have to be enabled in the automation just like other APEX components that support a row count)
  2. Make the apex_automation.log_x procedures Autonomous so that log content can be queried while the automation is still running. Currently we have to create our own autonomous logging procedure to do that. You should immediately see a row added to the Execution Log when an Automation is started with a status of “In Progress.” 
  3. Tap into DBMS_APPLICATION_INFO to track progress.There are two approaches here, one with SET_SESSION_LONGOPS and the other with SET_MODULE, SET_ACTION, and SET_CLIENT_INFO. For effective use, SET_SESSION_LONGOPS requires knowing the total work that needs to be done and progress, so it may not apply in all cases.
    For example, the total row count could be passed to the totalwork param in SET_SESSION_LONGOPS and sofar would be increased with each processed row. SET_MODULE could be used to set the Automation name and sessionid and SET_ACTION could be used to set the name of each Automation Action as it runs. 
  4. Ideally there would be a view or some other way to pass a progress percentage or other numeric value and a short status message (or current action name) in a way that can be used with something like the FOS Progress Bar plug-in: https://fos.world/ords/f?p=10000:4040:::NO:::
This is currently on the roadmap for a future release of Oracle APEX.

Comments

Comments

  • haniel b. OP 2.5 years ago (edited 2.5 years ago)

    I think this would go well with declarative progress bars: https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-1790

  • gberp OP 4 days ago

    This feature should be open to users, not just developers. Similarly, FR-3669 Monitor In-Progress Automations URL:  https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-3669&session=431633095398 this function, too, to open up to the user,  This function should also be made available to users at the same time. Only in this way can it be perfect and almost replace the concurrent request management function of EBS.  It can be integrated into a lightweight concurrent request management example for us to install, and then it can be provided to users for use, just like using the concurrent request management function in EBS.