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