Skip to Main Content
Feature Request FR-3591
Product Area APIs
Status CLOSED

4 Voters

API to create/update automations

martin.schouten Public · Jan 24 2024

Idea Summary
Extend the APEX_AUTOMATION package with APIs to create/update Automations

Use Case
This enables to create or modify Automations from within an APEX application. Currently this is only possible from within the App Builder. This enables the creation of applications which can maintain scheduled background processes. 

Preferred Solution (Optional)
New APIs in the APEX_AUTOMATION package: create_automation, update_automation. Key feature for my purpose is the ability to update the polling interval.

This is a great idea! You can already achieve this in APEX today with a slightly different approach.

Comments

Comments

  • martin.schouten OP 1.9 years ago

    Addition tot he preferred solution: If the create/update is not feasible, perhaps only an API to update the polling interval. (e.g.: APEX_AUTOMATION.update_interval)

  • bcrowley OP 1.9 years ago

    The ability to update the polling interval via API would be massively helpful.

  • carsten.czarski APEX Team OP 1.8 years ago

    I see the following way of doing this - which is actually rather simple - and also a nice combination of automations with DBMS_SCHEDULER. No need to update the application definition is required at all.

    • Change the automation to only run On Demand, and remove the schedule.
    • Create a scheduler job yourself (using DBMS_SCHEDULER), with the schedule you want. And the job simply runs the automation using APEX_AUTOMATION.EXECUTE. In this call, keep P_RUN_IN_BACKGROUND as false, as the scheduler job is already in the background.

    This will get you best of both worlds - all the automation actions and their meta data is stored in APEX, and the custom scheduler job allows flexible scheduling.

  • bcrowley OP 1.8 years ago

    @carsten.czarski This is the way we currently manage it, but it would be a better workflow to be able to see and manage the schedules through Apex.