Get DDL of a scheduler job - Oracle Database Script. SELECT dbms_metadata.get_ddl('PROCOBJ', '<JOB_NAME>', '<JOB_OWNER>') FROM dual; SELECT dbms_metadata.get_ddl('PROCOBJ', 'DUP_ACC', 'SCOTT') FROM dual;
SELECT dbms_metadata.get_ddl('PROCOBJ', '<JOB_NAME>', '<JOB_OWNER>') FROM dual; SELECT dbms_metadata.get_ddl('PROCOBJ', 'DUP_ACC', 'SCOTT') FROM dual;