导出job

SET SERVEROUTPUT OFF
SET TERMOUT OFF
set linesize 1000
set trimspool on
SET FEEDBACK OFF
set pagesize 0
set heading off
SPOOL D:\job.sql;
SELECT 'VAR JOB NUMBER' FROM DUAL;
select 'BEGIN' from dual;
SELECT  'SYS.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 => '''||INTERVAL||
                      ''');'
                      FROM user_jobs; 
SELECT 'COMMIT;' FROM DUAL;
SELECT 'END;' FROM DUAL;
SELECT CHR(47) FROM DUAL;
SPOOL OFF;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12961536/viewspace-1061341/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12961536/viewspace-1061341/