How to schedule jobs in Oracle
BEGIN
DBMS_SCHEDULER.DROP_JOB (‘TEST_JOB’);
END;
/
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => ‘TEST_JOB’,
job_type => ‘PLSQL_BLOCK’,
job_action => ‘UPDATE TABLE tblName set value=5;’,
start_date => sysdate,
repeat_interval => ‘FREQ=HOURLY; INTERVAL=1’, /* every one hour */
enabled => TRUE,
comments => ‘Test_JOb’);
END;
/
BEGIN
DBMS_SCHEDULER.ENABLE (‘TEST_JOB’);
END;
/