创建脚本过程:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'job_do_main_rtt',
job_type => 'STORED_PROCEDURE',
job_action => 'com_job.docachezmondate',
start_date => sysdate,
repeat_interval => 'FREQ=SECONDLY;INTERVAL=1',
comments => '每3秒汇总主界面的统计数据'
);
END;
/
启动job过程:
call dbms_scheduler.enable('job_do_main_rtt');
call dbms_scheduler.run_job('job_do_main_rtt');
停止job过程:
call dbms_scheduler.disable('job_do_main_rtt');
修改job过程:
BEGIN
DBMS_SCHEDULER.set_attribute( name =>'job_do_trun_tmp',
attribute => 'start_date',
VALUE => '18-9月 -12 12.20.00.000000 下午 +08:00');
END;
/