variable job1 number;
begin
sys.dbms_job.submit(job => :job1,
what => 'job_test;',
next_date => to_date('01-05-2007 01:00:00', 'dd-mm-yyyy HH24:mi:ss'),
interval => 'sysdate+1');
commit;
end;
/
创建Job
最新推荐文章于 2024-01-02 09:09:14 发布