mysql插入后定时删除_数据库定时任务添加、删除、修改

数据库添加定时任务.

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;');