job相干

分类: IT文章 • 2024-01-21 21:10:13

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;