How to schedule jobs in Oracle

Friday, 8 June 2007, 1:41 | Category : Database, Technology
Tags :

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;
/