ANNOUNCEMENT: community.oracle.com is currently Read only due to planned maintenance until 02:30 AM PST, 28-March-2015. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 12, 2012 2:47 AM by
How to schedule a job to run after completion of each run using DBMS_JOB ?
Oct 31, 2012 2:57 AM
Please let me know if the subject requirement can be fulfilled. I want to schedule a job using DBMS_JOB to run a script sequentially after completion of each run.
Thanks in advance.
This content has been marked as final.
Show 1 reply
Re: How to schedule a job to run after completion of each run using DBMS_JOB ?
Nov 12, 2012 2:47 AM
in response to
Instead to use the old dbms_job package use the dbms_scheduler and raise / catch events.
Oracle create dbms_scheduler also for this purpose you need.
You can find tons of examples on the web.