begin
sys.dbms_scheduler.create_job(job_name => 'XXCUPINFO',
job_type => 'STORED_PROCEDURE',
job_action => 'it_erp_r.Xxcus_Cpuinfo_Prc',
start_date => to_date('09-03-2022 17:55:00', 'dd-mm-yyyy hh24:mi:ss'),
repeat_interval => 'Freq=SECONDLY;Interval=30',
end_date => to_date(null),
job_class => 'DEFAULT_JOB_CLASS',
enabled => true,
auto_drop => false,
comments => '获取cpu使用率信息');
end;
————————————————
版权声明:本文为CSDN博主「刘文钊1」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/biqidaoer/article/details/123322240
建立定时job
于 2023-01-13 09:37:03 首次发布