oracle创建执行计划

作者: 周紫一 | 来源:发表于2018-06-20 17:51 被阅读40次

begin
  sys.dbms_scheduler.create_job(job_name            => 'ZHKUSER.禁毒高频人员预警信息更新',
                                job_type            => 'STORED_PROCEDURE',
                                job_action          => 'sp_update_drug_yjxx',
                                start_date          => to_date('18-04-2018 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                                repeat_interval     => 'Freq=Hourly;Interval=2',
                                end_date            => to_date(null),
                                job_class           => 'DEFAULT_JOB_CLASS',
                                enabled             => true,
                                auto_drop           => false,
                                comments            => '');
end;
/