oracle之job

作业每天23点
  declare
         varjob number;
  begin
         dbms_job.submit(varjob,'xjq;',sysdate,'TRUNC(SYSDATE + 1) +                 (23*60)/(24*60)');
         commit;
  end;
  /

 

begin
   dbms_scheduler.create_job
   (
      job_name        => 'test_xiq',
      job_type        => 'STORED_PROCEDURE',
      job_action      => 'xjq',
      repeat_interval => 'FREQ=SECONDLY',
      start_date      => sysdate,
      enabled         => true,
      comments        => 'New T_QZT_REPORT Table Rows'
   );
end;

 

begin
 variable job1 number;
 dbms_job.submit(:job1,'test;',sysdate,'sysdate+1/1440');
 COMMIT;
 END;
 
 begin
 dbms_output.put_line('ffdddddf');
 end ;
 
 
   variable job1 number;

　　begin

　　dbms_job.submit(:job1,'insertSysdate;',sysdate,'sysdate+1/1440');
--    execute dbms_job.remove(54659);
　　end;

    declare
    
   
　  begin
      dbms_output.put_line('fdsfds');
　　end;