Oracle job

Mark,关于job计划

参考：http://blog.csdn.net/lenovouser/article/details/45844939

--1创建表
       create table  job_test (
      id number(12),
       c_date date)
--2创建序列
      create sequence job_SEQ
        minvalue 1
        maxvalue 999999999999999999999999999
        start with 141
        increment by 1
         cache 20;
--3创建存储过程
     create or replace procedure pro_job_test is
   begin
      insert into job_test values(job_seq.nextval,sysdate);
     end pro_job_test;
--4创建job
   declare
   job number;
    begin
     sys.dbms_job.submit(job,'pro_job_test;',sysdate,'sysdate+1/1440');
    end;
--5运行job
  begin
    dbms_job.run(3);---3为此表job字段的内容select * from dba_jobs;
  end;
 --检查跑数情况select * from job_test
--6删除job
  begin
     dbms_job.remove(3);
    end;