如何在pl/sql中安排作业? [英] How to schedule a job in pl/sql?

问题描述

我创建了一个名称为

traffic_details_temp_send_mail;

如何使此过程每天上午10点运行?

How to make this procedure to run everyday at 10AM?

请帮助提供代码块.

谢谢.

推荐答案

您可以创建调度程序作业:

you can create a scheduler job:

begin
    dbms_scheduler.create_job(job_name        => 'TRAFFIC_DETAILS_JOB',
                              job_type        => 'STORED_PROCEDURE',
                              job_action      => 'traffic_details_temp_send_mail',
                              start_date      => systimestamp,
                              end_date        => null,
                              repeat_interval => 'freq=daily; byhour=10; byminute=0; bysecond=0;',
                              enabled         => true,
                              auto_drop       => false,
                              comments        => 'your description here.');
end;
/

然后，您可以在调度程序作业视图(user_scheduler_jobs等)中查看详细信息.请参阅此处以获取有关scehduler作业的信息.

then you can see the details in the scheduler job views (user_scheduler_jobs etc). see here for information on scehduler jobs.

这篇关于如何在pl/sql中安排作业?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！