variable 23 number;
begin
dbms_job.submit(:23, 'test_jobs;', sysdate, 'sysdate + 1/360');
commit;
end;
--任务删除
exec dbms_job.remove(1);
--任务查询
select * from user_jobs
--修改下次执行时间:
exec dbms_job.next_date(job,next_date);
--例如
exec dbms_job.next_date(28,to_date('20051010 03:00:05','yyyymmdd hh24:mi:ss'));