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;