DBMS JOB

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'TEST_SHEDULE',
job_type => 'STORED_PROCEDURE',
job_action => 'DPG.SP_SHEDULE_TEST',
start_date => to_date('26/05/2011 13:38:00' , 'DD/MM/RRRR HH24:MI:SS' ),
repeat_interval => 'FREQ=MINUTELY;INTERVAL=2;',
comments => 'My new job');
END;
/

DECLARE
BEGIN
DBMS_SCHEDULER.ENABLE('TEST_SHEDULE');
END;

-------------------------------------------------------------

EXEC dbms_scheduler.run_job('TEST_SHEDULE');

-------------------------------------------------------------

EXEC DBMS_SCHEDULER.DROP_JOB('my_java_job');

-------------------------------------------------------------

SELECT * FROM dba_scheduler_jobs