DBMS SCHEDULER

DBMS SCHEDULER is a more sophisticated job scheduler introduced in Oracle 10g. The older job scheduler, DBMS_JOB, is still available, is easier to use in simple cases and fit some needs that DBMS_SCHEDULER does not satisfy.   Create a job BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => ‘my_java_job’, job_type => ‘EXECUTABLE’, job_action => ‘/usr/bin/java myClass’, repeat_interval => ‘FREQ=MINUTELY’, enabled…