生成现有的job创建代码-移植用 (自动生成id)
SELECT 'declare job_id pls_integer;
begin
sys.dbms_job.submit(job => :job_id,
what => '''||replace(what,'''','''''')||''',
next_date => to_date('''||to_char(next_date, 'yyyy-mm-dd hh24:mi:ss')||',''yyyy-mm-dd hh24:mi:ss'')'',
interval => '''||interval||'''
);
commit;
end;
/'
FROM user_jobs
--------
生成现有的job创建代码 -移植用 (保持现有ID)
SELECT 'begin
sys.dbms_job.isubmit(job => '||job||',
what => '''||replace(what,'''','''''')||''',
next_date => to_date('''||to_char(next_date, 'yyyy-mm-dd hh24:mi:ss')||',''yyyy-mm-dd hh24:mi:ss'')'',
interval => '''||interval||'''
);
commit;
end;
/'
FROM user_jobs