Monday, November 20, 2017

Extract DDL of scheduler job in oracle

set long 10000
select dbms_metadata.get_ddl('PROCOBJ','SCOTT_JOB','SCOTT') from dual;
Note : The job in sys cannot be extracted, so, copy it to another user and then extract
exec dbms_scheduler.copy_job('SYS.MY_JOB','SCOTT.MY_JOB');