摘要: PROCEDURE PROC_START_WF_JOB(IN_WF_PARAM IN OUT PROC_WF_PARAM_TYPE) AS V_RUNCNT NUMBER(8); V_PROGRAMNAME VARCHAR2(30); V_JOBNAME VARCHAR2(30); V_PROCNA 阅读全文
posted @ 2018-08-30 15:14 Ayumie 阅读(304) 评论(0) 推荐(0) 编辑
摘要: SELECT * FROM DBA_SCHEDULER_JOBS t WHERE OWNER='TEST';SELECT * FROM DBA_SCHEDULER_PROGRAMS WHERE OWNER='TEST';--1.stop jobs and enable/disable jobsBEG 阅读全文
posted @ 2018-08-30 11:06 Ayumie 阅读(352) 评论(0) 推荐(0) 编辑