数据库定时任务添加、删除、修改

数据库添加定时任务.
begin
sys.dbms_scheduler.create_job(job_name => 'JOB_MUSIC_USERDATA_UPDATE',
job_type => 'STORED_PROCEDURE',
job_action => 'p_music_userdata_update',
start_date => to_date('14-05-2019 00:05:00', 'dd-mm-yyyy hh24:mi:ss'),
repeat_interval => 'Freq=Daily;ByHour=00;ByMinute=05;BySecond=00',
end_date => to_date(null),
job_class => 'DEFAULT_JOB_CLASS',
enabled => true,
auto_drop => true,
comments => '');
end;
/

---停止Job
exec dbms_scheduler.disable('job_music_userdata_update'); ---job名称
---删除job
exec dbms_scheduler.drop_job('job_music_userdata_update'); ---job名称

修改job

exec dbms_scheduler.set_attribute(name => 'JOB_P_FILEMONITOR_DATA_MONTH',attribute => 'REPEAT_INTERVAL',value => 'freq=monthly;bymonthday=1;byhour=3;byminute=40;bysecond=0;interval=1;');