variable ds number;
begin
dbms_job.submit(:ds,'insert into testdb values(500);',sysdate,'sysdate+1/360');
commit;
end;
variable ds number;
begin
dbms_job.submit(:ds,'insert into testdb values(500);',sysdate,null);
commit;
end;
variable ds number;
begin
dbms_job.submit(:ds,'insert into testdb values(600);',to_date('2005-12-01 10:35:30','yyyy-mm-dd hh24:mi:ss'),'sysdate+1/360');
commit;
end;
-------------------------------------------------------
select job from user_jobs;
-------------------------------------------------------
begin
dbms_job.remove(1);
dbms_job.remove(2);
commit;
end;