Database Reference
In-Depth Information
Syntax
DBMS_IJOB.BROKEN (
job IN BINARY_INTEGER,
broken IN BOOLEAN,
next_date IN DATE DEFAULT SYSDATE);
Parameters
Parameter
Description
job
Job number; corresponds to DBA_JOBS.JOB
broken
job as not broken
TRUE: mark job as broken, FALSE: mark
next_date
Next time and date to run job
Usage Notes
Because there is no public synonym for
DBMS_IJOB
you need to qualify the package name with
the schema name SYS. For jobs with status
BROKEN=Y
the column
NEXT_DATE
always has the value
January 1st, 4000.
Examples
Here's an example of marking a job in a foreign schema as broken. It fails with
DBMS_JOB
, but
succeeds with
DBMS_IJOB
.
SQL> SHOW USER
USER is "NDEBES"
SQL> SELECT role FROM session_roles WHERE role='DBA';
ROLE
------------------------------
DBA
SQL> SELECT job, what, broken FROM dba_jobs WHERE priv_user='PERFSTAT';
JOB WHAT BROKEN
--- --------------- ------
1 statspack.snap; N
SQL> EXEC dbms_job.broken(1,true)
BEGIN dbms_job.broken(1,true); END;
*
ERROR at line 1:
ORA-23421: job number 1 is not a job in the job queue
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 245
SQL> EXEC sys.dbms_ijob.broken(1, true)
PL/SQL procedure successfully completed.