declare
job_id pls_integer;
begin
sys.dbms_job.submit(job => job_id,
what => ‘clear_fr_info;’,
next_date => sysdate,
interval => ‘sysdate+30/86400’);
commit;
end;
/
用sql脚本写job
最新推荐文章于 2022-03-01 09:06:58 发布
declare
job_id pls_integer;
begin
sys.dbms_job.submit(job => job_id,
what => ‘clear_fr_info;’,
next_date => sysdate,
interval => ‘sysdate+30/86400’);
commit;
end;
/