Hi,
I am submitting a package using APEX_PLSQL_JOB.SUBMIT_PROCESS on the click of a button.
l_job_id := APEX_PLSQL_JOB.SUBMIT_process ( 'BEGIN my_pkg; END;' );
Now I have validations that the button cannot be submitted again, which works fine.
I want to inform the user once the process has completed. How do I do that?.
I send out a mail once the process is complete. This is sent from the package.
The whole process takes around 20 mins, so the mail option is fine but I also want some kind of a indication on the APEX page that the process completed successfully.
I know about this table htmldb_plsql_jobs where I can check the status, but once I submit the job it runs asyncronously. So at what point should I check this table?
Thanks,
VS.