直接在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;