摘要：
/*********************************************************************/实验步骤create chain---my_chain1create chain step1---my_prog1--my_porc1create chain step2---prog1--proc1--logcreate chain rule1---chain step1---my_prog1create chain rule2---chain step2---step1 successcheck/*************************** 阅读全文
摘要：
Creating Job ChainsCreate a chain object.Define chain steps.Define chain rules.Starting the chain:Enable the chainCreate a job that points to the chain.chain执行步骤，如果chain A 执行成功了，就执行chain B，执行完B之后，还可以根据条件进行switch，执行chain C或者chain D.chain执行的各个步骤，可以嵌套.一个chain中的子步骤也可以是一个chain.Example of a Chain创建chain步骤 阅读全文
摘要：
Creating Complex Schedules/* ================================================================================== Creating Complex Schedules ==================================================================================*/BEGIN DBMS_SCHEDULER.CREATE_SCHEDULE( ... 阅读全文
摘要：
1、在创建scheduler时，设置start_date =>systimestamp要比start_date => sysdate要好一些,systimestamp可以自动调整时区.2、job创建参数中，job_type的参数值类型 STORED_PROCEDURE------->job执行存储过程 PLSQL_BLOCK------------>pl/sql匿名块 EXECUTABLE------------->可执行操作系统命令 The type of this job.Valid values are: 'PLSQL_BLOCK', 阅读全文
摘要：
Persistent Lightweight JobsPersistent lightweight jobs:Reduce the overhead and time required to start a jobHave a small footprint on disk for the job metadata and for storing run-time data.Are created from a job template(in the commad line)创建lightweight job的语法BEGIN DBMS_SCHEDULER.CREATE_JOB( ... 阅读全文