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的创建

上一篇:Photoshop 梦幻的彩色发光文字效果


下一篇:MySQL中以数值类型存储IP地址