?
Solved

Break job in dba_jobs

Posted on 2006-11-08
3
Medium Priority
?
4,281 Views
Last Modified: 2008-01-09
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?

0
Comment
Question by:xoxomos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:xoxomos
ID: 17900186
Also tried to remove:
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

0
 
LVL 18

Accepted Solution

by:
rbrooker earned 1200 total points
ID: 17900333
Hi,

you need to be the owner of the job to remove / break the job.

select log_user, priv_user, schema_user from dba_jobs where job = 121

one of these three columns is the user you need to be to manipulate the job. ( i can never remember which one. )
also, remember to COMMIT after each job change...

good luck :)
0
 

Author Comment

by:xoxomos
ID: 17900444
Yup.  That's right.  Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question