2018年8月30日
Oracle create program and job for scheduler jobs
摘要： 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 阅读(317) 评论(0) 推荐(0)
Stop_Disable_Drop_Scheduler_JOB
摘要： 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 阅读(362) 评论(0) 推荐(0)