1. createtablea(adate);
3. createorreplaceproceduretestas
4. begin
5. insertintoavalues(sysdate);
6. end;

1. declare
2. job1number;
3. begin
4. dbms_job.submit(job1,
5. what=>'test;',
6. next_date=>sysdate,
7. interval=>'sysdate+1/(24*60*60)');--每隔1s处理一次用户表
8. commit;
9. end;

1. selectjob,broken,what,interval,t.*fromuser_jobst;

1. begin
2. dbms_job.remove('24');
3. commit;
4. end;

1. begin
2. dbms_job.run(24);--24jodid
3. --commit;
4. end;
   

create or replace procedure backUpDayMessage as begin insert into t_call_message_2017 select * from t_Call_Message t where to_char(t.visit_time,'YYYYMMDD') = to_char(TRUNC(sysdate - 1),'YYYYMMDD'); end; declare backUpDayMessageJob number; begin dbms_job.submit(backUpDayMessageJob,what => 'backUpDayMessage;',next_date => TRUNC(sysdate) + 1,interval => 'TRUNC(SYSDATE) +1+ 1 / 24'); commit; end;