BROKEN procedure
This procedure sets the broken flag. Broken jobs are never run. Syntax
DBMS_JOB.BROKEN (
job IN BINARY_INTEGER,
broken IN BOOLEAN,
next_date IN DATE DEFAULT SYSDATE);
This procedure sets the broken flag. Broken jobs are never run. Syntax
DBMS_JOB.BROKEN (
job IN BINARY_INTEGER,
broken IN BOOLEAN,
next_date IN DATE DEFAULT SYSDATE);
但不知job是否报错。
alter procedure name_pro disable;
job IN BINARY_INTEGER,
broken IN BOOLEAN,
next_date IN DATE DEFAULT SYSDATE);先把broken(job_id, true),
再 broken(job_id, false) 改回来!