oracle10g ocp学习笔记系列之CH16Automating Tasks with the Scheduler

Three basic components:
job: what and when
schedule:when and how many times
program:a collection about job?

Resource concepts:
job class:a category of jobs than share common resource
resource consumer group:
resource plan:prioritize resources
window:an interval of time with a well-defined beginning and end
window group:a group of window

job coordinator is a backgroup process(cjqNNN) that is automatically started when jobs(windows) must be run and sleep automatically.
P450 Privileges for Scheduler Components
P453 create_job example

important knowledge:repeat_interval  2 types
calendaring expression:freq决定周期，interval决定多少个freq.specifiers特殊的。 详细参数范围见P455
datetime expression:

P458 create schedules(which the job can use):resource_consumer_group and service parameters conflict
P463 create job class:default_job_class  ->default_consumer_group
job logging P464
P465 Creating a window
knowledge:Priority
job class priority > job priority
use set_attribute set the priority P468
P469 enable and disable scheduler P470 manage jobs P471 manage programs P473 manage schedule P474 manage windows
P476 window priority (not recommend overlapping windows)
P477 manage attributes of scheduler components
P480 view job execution,logs:DBA_scheduler_job_run_details;DBA_SCHEDULER_JOB_LOG
p482 PURGE JOB LOGS
p484 DATA DICTIONARY VIEWS