Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4509
  • Last Modified:

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?

0
xoxomos
Asked:
xoxomos
  • 2
1 Solution
 
xoxomosAuthor Commented:
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
 
rbrookerCommented:
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
 
xoxomosAuthor Commented:
Yup.  That's right.  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now