APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schedule a stored procedure every 5 minutes

724314Sep 24 2009 — edited Sep 24 2009

Could someone please help,

Currently I have a job that runs as a background process (via APEX JOB) when the user selects a button in my APEX application.

However, I wish to run the same procedure as a background process every 5 minutes (automatically) so the user is not expected to remember to keep running the job. Can anybody advise the best way to do this?

I have found examples of using DBMS_JOB, DBMS_SCHEDULER etc. but none of the examples help, as I need to record the job number (in a seperate jobs table) so that I can develop a APEX report which shows all jobs currently running, or completed (detailing the date and time they were run).

Thanks in advance for any help you can give.

Cheers

Steve

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2009

Added on Sep 24 2009

#apex, #apex-discussions, #database

4 comments

8,292 views