The Scheduler supports types

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14220/mgmt_db.htm#sthref2285

 

Schedule JobExecution

 

The most basic capability of a job scheduler is to schedule theexecution of a job. The Scheduler supports both time-basedand event-based scheduling.--调度可以支持的类型为：

基于时间和基于事件的调度

 

NO1：Time-basedscheduling

 

Time-based scheduling enables users to specify a fixeddate and time (for example, Jan. 23rd 2006 at 1:00 AM), a repeatingschedule (for example, every Monday), or a defined rule (forexample the last Sunday of every other month or the fourth Thursdayin November which defines Thanksgiving).

Users can create new composite schedules with minimum effort bycombining existing schedules. For example if a HOLIDAY and WEEKDAYschedule were already defined, a WORKDAY schedule can be easilycreated by excluding the HOLIDAY schedule from the WEEKDAYschedule.

Companies often use a fiscal calendar as opposed to a regularcalendar and thus have the requirement to schedule jobs on the lastworkday of their fiscal quarter. The Scheduler supportsuser-defined frequencies which enables users to define not only thelast workday of every month but also the last workday of everyfiscal quarter.

 

NO2：Event-Based Scheduling

 

Event-based scheduling as the name implies triggers jobsbased on real-time events.(--as the nameimplies译为：顾名思义.基于事件的调度顾名思义应用于基于实时事件的触发器作业。) Events aredefined as any state changes or occurrences in the system such asthe arrival of a file. Scheduling based on events enables you tohandle situations where a precise time is not known in advance forwhen you would want a job to execute.