Custom repeat_interval for dbms_scheduler

Monday, August 24, 2009
By Steve

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');

Leave a Reply