Solved

Break job in dba_jobs

Posted on 2006-11-08
3
4,131 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
  • 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 300 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

777 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