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;