les automating tasks with the scheduler用调度程序自动化任务

KeyComp.&StepsKeyComp.&StepsJob

创建程序创建调度程序

program_name=>'CALC_STATS2',program_action=>program_type=>'STORED_PROCEDURE'enabled=>TRUE);/, repeat_interval=>repeat_interval=>schedule_name=>'stats_schedule',start_date=>SYSTIMESTAMP,end_date=>SYSTIMESTAMP+30,comments=>'Everyhour');/ SELECTjob_name,status,error#,run_durationFROMUSER_SCHEDULER_JOB_RUN_DETAILS; STATUSERROR#0 &Steps JobChains&Steps JobChains job_type=>job_action=>'/home/usr/dba/rman/nightly_incr.sh',start_date=>SYSDATE,/*nextnightat11:00PM*/comments=>'Nightlyincrementalbackups');/ (在何处把消息排队来启动你的作业条件(和OracleStreamAQ规则相同语法)，TRUEOracleDatabase

Event

job_type=>job_action=>'/home/usr/dba/rman/report_failure.sh',startdate=>SYSTIMESTAMP,event_condition=>'tab.user_data.object_owner=''HR''andtab.user_data.object_name=''DATA.TXT''andtab.user_data.event_type=''FILE_ARRIVAL''andtab.user_data.event_timestamp<9queue_spec=>

提 的例子'raise_events', &Steps&Steps JobChains 允 创建一个指 的作业Job Dependency55

Load_data_evt

Do_bulk_load

33

4(4 112345 1DBMS_SCHEDULER.DEFINE_CHAIN_EVENT_STEP1chain_name=>'bulk_load_chain',step_name=>'load_data_evt',event_condition=>'tab.user_data.object_owner=''HR''andtab.user_data.object_name=''DATA.TXT''andtab.user_data.event_type=''FILE_ARRIVAL''',queue_spec=>DBMS_SCHEDULER.DEFINE_CHAIN_STEP chain_name=>step_name=>'do_bulk_load',program_name=>'hr.load_data_prog);DBMS_SCHEDULER.DEFINE_CHAIN_STEPchain_name=> step_name=>'rebuild_indx',program_name=>'hr.rebuild_indexes'); DBMS_SCHEDULER.ENABLE('bulk_load_chain');/DBMS_SCHEDULER.CREATE_JOB => =>'CHAIN', =>'bulk_load_chain',repeat_interval=>/

=> |||||||| KeyKeyComp.&StepsJob consumergroup

n

Job

Job

EXECUTEjob_class_nameEXECUTEjob_class_name=>'ADMIN_JOBS',resource_consumer_group=>'DAYTIME_JOBS',-logging_level=>DBMS_SCHEDULER.LOGGING_OFF); /me=>'DEC_NIGHTS',n=>e=>'01-DEC-0306.00.00PMEST',terval=>'FREQ=DAILY;BYHOUR=18',=>'0=>'31-DEC-0306.00.00AM=>'Everydayat6:00 12352