Home » SQL & PL/SQL » SQL & PL/SQL » dba_jobs_running
dba_jobs_running [message #7845] Fri, 11 July 2003 14:53 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
I have a job that is currently running. I can see that it has failed few times and I wish to stop it. I have run:

SQL> exec dbms_job.broken(581,true);

SQL> commit;

But the job is still listed in the dba_jobs_running view. How do I get the job to stop?

Report message to a moderator

Re: dba_jobs_running [message #7846 is a reply to message #7845] Fri, 11 July 2003 16:04 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You'll need to kill the session that was running the job prior to the time of the job break.

Report message to a moderator

Re: dba_jobs_running [message #7847 is a reply to message #7846] Fri, 11 July 2003 16:16 Go to previous message
Joe
Messages: 138
Registered: November 1999
Senior Member
Todd,

Thanks. Since my intentions were to actually just replace the job. I simply performed a dbms_job.remove(#) and that did the trick as well. Thanks again.

joe

Report message to a moderator

Previous Topic: Constant array in PL/SQL?
Next Topic: PL/SQL Gateway
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 17:59:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.