APEX 21.2
We built some APEX automation in DEV (to run every 15 minutes), made sure it was working and deployed it to QA/UAT. To my surprise, it did not run at all. Here are some details from APEX_APPL_AUTOMATIONS in QA
TRIGGER_TYPE_CODE = POLLING
POLLING_STATUS = Active
Polling last run and next run timestamp are blank
Nothing in apex_automation_log
When I run apex_automation.enable manually, it jump starts the automation and things start to work as expected
Questions
When an application is exported/imported from one database to another, does the target database delete all the automation setup and re-install it from the app import?
If I include the apex_automation.enable API in the app code, it keeps bumping ahead the next run time by the duration (15 minutes in this case) so the job never actually executes.
Clearly, I am missing something in how this is supposed to work. Should we be including a one-time call to apex_automation.enable as part of deploying the application?
When is it appropriate to use apex_automation.enable/disable in application code?
Thanks