Custom repeat_interval for dbms_scheduler

Nothing fancy today, just a simple test case regarding the subject line 🙂

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