Custom repeat_interval for dbms_scheduler
Nothing fancy today, just a simple test case regarding the subject line
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | CREATE OR REPLACE FUNCTION mytime RETURN DATE AS BEGIN RETURN SYSDATE + 5 / 1440; END; / CREATE TABLE foo (c DATE); CREATE OR REPLACE PROCEDURE test_interval AS BEGIN INSERT INTO foo VALUES(SYSDATE); COMMIT; END; / exec dbms_scheduler.create_job('myjob','plsql_block',job_action=>'begin test_interval; end;',repeat_interval => 'mytime'); exec dbms_scheduler.enable('myjob'); |