Home » RDBMS Server » Server Administration » Help Needed - to stop jobs
Help Needed - to stop jobs [message #405980] Mon, 01 June 2009 05:01 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

I want to stop some jobs which are running in Oracle. I used dbms_job.remove and jobs are removed from dba_jobs table. But how to stop these jobs from running queue.So cany one please let me know the solution for this?

Thank you
Re: Help Needed - to stop jobs [message #405985 is a reply to message #405980] Mon, 01 June 2009 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Kill the associated session.

Regards
Michel
Re: Help Needed - to stop jobs [message #406372 is a reply to message #405980] Wed, 03 June 2009 13:29 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i belive the below procedure let you remove .

dba_jobs
column log_user userA ,
column schema_user UserB

checkout for any UserB session running this job.
kill the session.
break the job(dbms_job.broken)
login to UserA ,remove the job(dbms_remove).

pls correct me if i am wrong.
Re: Help Needed - to stop jobs [message #406374 is a reply to message #406372] Wed, 03 June 2009 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you are wrong OP and I are also wrong as this is what we said (apart from the broken step which is useless).

Regards
Michel

[Updated on: Wed, 03 June 2009 13:42]

Report message to a moderator

Re: Help Needed - to stop jobs [message #406375 is a reply to message #405980] Wed, 03 June 2009 13:44 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
My point was sometime you may need to break a job, Killing the session alone willnot let you remove.
Re: Help Needed - to stop jobs [message #406376 is a reply to message #405980] Wed, 03 June 2009 13:45 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
ok.may be i am wrong.Thanks
Previous Topic: ORACLE 10.2 not able to start listener (merged 3)
Next Topic: SQL ID
Goto Forum:
  


Current Time: Wed Dec 07 22:12:52 CST 2016

Total time taken to generate the page: 0.11872 seconds