本文共 2218 字，大约阅读时间需要 7 分钟。

?????Oracle PL/SQL job?????????
????????????Oracle?????PL/SQL job???????????????????????????????????????
????????
????????????Oracle?????job???????????Oracle??????????????????job??????dba_jobs?dba_jobs_running?user_jobs??????dbms_job.submit?dbms_job.run?????
???????????
1. job?????  
   ????????job???????????job?????????????????  
   ```sql
   select * from dba_jobs_running;

??????job????????job?broken????????????????job????

dbms_job.broken(job_id, isbroken, last_date);

????????job??????

dbms_job.remove(job_id);

2. job???????

   job???????????????????????????????????
   • ??dbms_job.submit?????????interval??????

   dbms_job.submit(job_id => :job, 
                  what => 'your_procedure_name', 
                  next_date => to_date('2023-10-01 09:00:00', 'yyyy-mm-dd hh24:mi:ss'), 
                  interval => 'sysdate + 1/(24*60*60)');

   • ?procedure???dbms_output.put_line??????????????????

   create or replace procedure pro_job_print  
   as  
   begin  
      dbms_output.put_line(to_char(sysdate, 'dd-mm-yyyy hh24:mi:ss'));  
      insert into tab_time values(sysdate);  
   end;

   • ????job???????????????job??????????

   alter system kill session 'SID,serial#';

3. job?????

   ??dbms_job.submit???????????????????????????????
   • ???????job????????????

   select job_id from dba_jobs where who owns the job?

   • ??interval???????????????????????

   interval => 'sysdate + 10/(24*60*60)';

   • ???????????Oracle????????????????????

???????

????job?????????????????

4. ??job_queue_processes???

   Oracle???job_queue_processes???????0?????job?????????????????????

   alter system set job_queue_processes = 39 scope = spfile;

   ??????????job????????

5. ?????job_queue_interval?

   job_queue_interval????job???????????????????????????

   alter system set job_queue_interval = 10;

6. ????job???

   ???????????job??????????PL/SQL???????????

   declare  
      job_ids number;  
   begin  
      for i in 1..10  
      loop  
         job_ids := job_ids + 1;  
         dbms_job.submit(job_id => job_ids,  
                        what => 'your_procedure_name',  
                        next_date => to_date('2023-10-01 09:00:00', 'yyyy-mm-dd hh24:mi:ss'),  
                        interval => 'sysdate + 1/(24*60*60)');  
      end loop;  
   end;

????

????????????????Oracle PL/SQL job?????????????????????????????????????????job?????????????????????job??????

转载地址：http://dopfk.baihongyu.com/