笔记：创建Oracle数据库scheduler job

创建job

begin
   dbms_scheduler.create_job(job_name        => 'J_MDSDE_COUNT',
                             job_type        => 'STORED_PROCEDURE',
                             job_action      => 'pro_mdsde_count', 
                             start_date      => to_date('2020-12-08 02:00:00','yyyy-mm-dd hh24:mi:ss'),
                             repeat_interval => 'freq=daily;byhour=2',
                             comments        => '统计数据汇总到表');
end;

激活job

exec dbms_scheduler.enable('J_MDSDE_COUNT'); 

删除job

EXEC DBMS_SCHEDULER.DROP_job('J_MDSDE_COUNT');

查询job

select * from dba_scheduler_jobs;

需要的权限：

grant   create  job  to  user_name;
还不够？
grant scheduler_admin to user_name;
grant manage scheduler to user_name;

repeat_interval 相关：
FREQ 关键字用来指定间隔的时间周期，可选参数有：YEARLY, MONTHLY, WEEKLY, DAILY, HOURLY, MINUTELY, and SECONDLY，分别表示年、月、周、日、时、分、秒等单位

INTERVAL 关键字用来指定间隔的频繁，可指定的值的范围从1-99