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

posted @ 2017-04-24 10:11  mosakashaka  阅读(838)  评论(0编辑  收藏  举报