https://dba.stackexchange.com/questions/73836/exporting-scheduled-jobs-in-oracle
SELECT dbms_Metadata.get_ddl( 'PROCOBJ', <<job name>>,54)"><<schema>>) FROM dual
如果job名称为'job_abc',schema为text_schema,则查看方式为
SELECT dbms_Metadata.get_ddl( 'PROCOBJ','job_abc','text_schema' ) FROM dual
原文链接:https://www.f2er.com/oracle/209506.html