且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

创建Oracle Scheduler作业

更新时间:2021-12-13 07:56:01

使用以下间隔定义:

'freq=daily;byhour=8,10,12,14,16;byminute=0'

因此创建作业的完整代码如下:

So the full code to create the job would be something like:

DBMS_SCHEDULER.create_job(
        job_name => 'the_job',
        job_type => 'STORED_PROCEDURE',
        job_action => 'YOUR_PROCEDURE',
        repeat_interval => 'freq=daily;byhour=8,10,12,14,16;byminute=0',
        enabled => TRUE);