oracle job导出导入

直接在command命令窗口执行如下sql即可， 大号字体的路径是你自己设置的，

SET SERVEROUTPUT OFF
SET TERMOUT OFF
set linesize 1000
set trimspool on
SET FEEDBACK OFF
set pagesize 0
set heading off
SPOOL c:\job输出脚本路径.sql;
SELECT 'declare job  number;' FROM DUAL;
select 'BEGIN' from dual;
SELECT  'dbms_job.submit(job => job,
                      what => '''||what||
                      ''',
                      next_date => to_date('''||to_char(next_date,'dd-mm-yyyy hh24:mi:ss')||
                      ''', ''dd-mm-yyyy hh24:mi:ss''),
                      interval => '''||REPLACE(INTERVAL, '''', '''''' )||
                      ''');'
                      FROM user_jobs; 
SELECT 'END;' FROM DUAL;
SELECT CHR(47) FROM DUAL;
SELECT 'COMMIT;' FROM DUAL;


SPOOL OFF;