生成现有的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