oracle SCHEDULER

从Oracle 10g开始，推荐使用DBMS_SCHEDULER包，因为它提供了更强大的功能和灵活性，包括更复杂的调度规则、依赖管理和事件驱动等

1. 用法

DBMS_SCHEDULER.CREATE_JOB (job_name             IN VARCHAR2,job_type             IN VARCHAR2,job_action           IN VARCHAR2,number_of_arguments  IN PLS_INTEGER              DEFAULT 0,start_date           IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,repeat_interval      IN VARCHAR2                 DEFAULT NULL,end_date             IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,job_class            IN VARCHAR2                 DEFAULT 'DEFAULT_JOB_CLASS',enabled              IN BOOLEAN                  DEFAULT FALSE,auto_drop            IN BOOLEAN                  DEFAULT TRUE,comments             IN VARCHAR2                 DEFAULT NULL,