oracle中 导出job定义语句

https://dba.stackexchange.com/questions/73836/exporting-scheduled-jobs-in-oracle


SELECT dbms_metadata.get_ddl( 'PROCOBJ', <<job name>>, <<schema>> )
  FROM dual

如果job名称为'job_abc', schema为text_schema,则查看方式为

SELECT dbms_metadata.get_ddl( 'PROCOBJ', 'job_abc', 'text_schema' )
  FROM dual

原文地址:https://www.cnblogs.com/mosakashaka/p/12534666.html