Can you advise how dbms_scheduler works and commands we can use to schedule the job?
As part of a customization which I am planning to implement, I would like to explore the possibility of scheduling the execution of a PL/SQL procedure from within the Database. Which means, by some setup within the database, I want to run a package/procedure on the nightly basis.
One of the job scheduler introduced in Oracle 10g is DBMS SCHEDULER.
Could you let me know the best option to schedule execution of a PL/SQL procedure within the database.
One of the job scheduler introduced in Oracle 10g is DBMS SCHEDULER.
Could you let me know the best option to schedule execution of a PL/SQL procedure within the database.
0