xoxomos
asked on
Break job in dba_jobs
I tried to break a job in dba_jobs but obviously not the right way.
SQL> select job, what from dba_jobs;
JOB WHAT
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
121 analyze_my.bbtabs;
141 analyze_my.bbtabs;
161 analyze_my.bbtabs;
SQL> exec dbms_job.broken(121,true);
BEGIN dbms_job.broken(121,true); END;
*
ERROR at line 1:
ORA-23421: job number 121 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 245
ORA-06512: at line 1
How do I break those jobs?
SQL> select job, what from dba_jobs;
JOB WHAT
--------------------------
121 analyze_my.bbtabs;
141 analyze_my.bbtabs;
161 analyze_my.bbtabs;
SQL> exec dbms_job.broken(121,true);
BEGIN dbms_job.broken(121,true);
*
ERROR at line 1:
ORA-23421: job number 121 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 245
ORA-06512: at line 1
How do I break those jobs?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yup. That's right. Thanks
ASKER
SQL> exec dbms_job.remove(121);
BEGIN dbms_job.remove(121); END;
*
ERROR at line 1:
ORA-23421: job number 121 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 171
ORA-06512: at line 1