Scheduling jobs on Oracle Apex

So I’m working with apex to get some things done and I think it’s a nice tool, it already has everything in it so you can create quick reports and other fancy web tools so I designed a report on PL/SQL and I had the need to have it run daily, after finding out how I thought you might find useful this snippets of code.

We use the dbms_scheduler.create_job() API to easily add jobs to APEX’s scheduler:

To check for existing jobs on the scheduler we can query the user_scheduler_jobs table;

And lastly and just as useful, to delete a job from the scheduler we use the dbms_scheduler.drop_job() API call:

Hope you guys on the internetz find this useful.

VN:F [1.9.22_1171]
Rating: +3 (from 3 votes)

2 thoughts on “Scheduling jobs on Oracle Apex

  1. I need to truncate a table every 24 hours, and your code looks like I can tweak it to do that. But I have no idea how to implement that code?

    Using APEX, where would I “put” that code?

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *