ORACLE 创建job 定时执行带参数的存储过程

创建存储过程 （往person表中插入人名）

PROCEDURE INSERTPERSON(
                            name    IN VARCHAR2
                            ) AS
  BEGIN
    -- TODO: PROCEDURE TEST.INSERTPERSON所需的实施
    insert into person values (name);
    commit;
  END INSERTPERSON;

创建job

DECLARE  
X NUMBER;  --设置jobid
BEGIN  
SYS.DBMS_JOB.SUBMIT  
( job => X ,
what => 'DECLARE
  name VARCHAR2(10):=''jax'';
BEGIN
  TEST.INSERTPERSON(name);
END;' ,
next_date => to_date('17-03-2021 14:21:41', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate+1/24' ,
no_parse => TRUE  
);  
COMMIT;  
END;  

立即执行job

begin  
dbms_job.run(jobid);  
end; 

查询创建对的job

select * from user_jobs

删除job

begin
   dbms_job.remove(4);--和select * from user_jobs; 中的job值对应
end;