job相干

job相关

创建job
DECLARE
  JOBID NUMBER;
BEGIN
  SYS.DBMS_JOB.SUBMIT (
    job => JOBID,
    what => 'P_RECORD_LONGSQL;',
    next_date => sysdate,
    interval => 'SYSDATE + 10/(60*24)');
  COMMIT;
END;
/

job删除不掉，方法：

sys用户
exec dbms_ijob.remove(jobno);

运行job
exec dbms_job.run(73);

查看全部job
select * from dba_jobs;