Oracle DBMS_Jobs的创建

本文主要是介绍Oracle DBMS_Jobs的创建，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

begin
  timer_auto_add_newpartitions('STN_AREASKHOURSRC','AREABG');
end;

begin
  timer_auto_add_newpartitions('STN_FIVEMINUTE','AREABG');
end;
begin
  timer_auto_add_newpartitions('STN_ONESECONDDATA','AREABG');
  end;
begin
  timer_auto_add_newpartitions('STN_STATEHOUR','AREABG');
  end;
begin
  timer_auto_add_newpartitions('STN_STATIONQCHOUR','AREABG');
  end;
begin
  timer_auto_add_newpartitions('STN_THIRTYSECONDDATA','AREABG');
  end;




declare jobno pls_integer; 

begin
  sys.dbms_job.submit(job => jobno,
                      what => 'timer_auto_add_newpartitions(''STN_AREASKHOURSRC'',''AREABG'');',
                      next_date => to_date('01-05-2021 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'TRUNC(LAST_DAY(SYSDATE))+1+1/24');
  commit;
end;




declare jobno pls_integer; 
begin
  sys.dbms_job.submit(job => jobno,
                      what => 'timer_auto_add_newpartitions(''STN_FIVEMINUTE'',''AREABG'');',
                      next_date => to_date('01-05-2021 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'TRUNC(LAST_DAY(SYSDATE))+1+1/24');
  commit;
end;

declare jobno pls_integer; 
begin
  sys.dbms_job.submit(job => jobno,
                      what => 'timer_auto_add_newpartitions(''STN_ONESECONDDATA'',''AREABG'');',
                      next_date => to_date('01-05-2021 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'TRUNC(LAST_DAY(SYSDATE))+1+1/24');
  commit;
end;

declare jobno pls_integer; 
begin
  sys.dbms_job.submit(job => jobno,
                      what => 'timer_auto_add_newpartitions(''STN_STATEHOUR'',''AREABG'');',
                      next_date => to_date('01-05-2021 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'TRUNC(LAST_DAY(SYSDATE))+1+1/24');
  commit;
end;


declare jobno pls_integer; 
begin
  sys.dbms_job.submit(job => jobno,
                      what => 'timer_auto_add_newpartitions(''STN_STATIONQCHOUR'',''AREABG'');',
                      next_date => to_date('01-05-2021 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'TRUNC(LAST_DAY(SYSDATE))+1+1/24');
  commit;
end;


declare jobno pls_integer; 
begin
  sys.dbms_job.submit(job => jobno,
                      what => 'timer_auto_add_newpartitions(''STN_THIRTYSECONDDATA'',''AREABG'');',
                      next_date => to_date('01-05-2021 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'TRUNC(LAST_DAY(SYSDATE))+1+1/24');
  commit;
end;

这篇关于Oracle DBMS_Jobs的创建的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！