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: +1 (from 1 vote)

Leave a Reply

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