OraFAQ Forum: Server Administration » Help Needed

Home » RDBMS Server » Server Administration » Help Needed - to stop jobs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help Needed - to stop jobs [message #405980]

Mon, 01 June 2009 05:01

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

Report message to a moderator

Re: Help Needed - to stop jobs [message #405985 is a reply to message #405980]

Mon, 01 June 2009 06:23

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Kill the associated session.

Regards
Michel

Report message to a moderator

Re: Help Needed - to stop jobs [message #406372 is a reply to message #405980]

Wed, 03 June 2009 13:29

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.

Report message to a moderator

Re: Help Needed - to stop jobs [message #406374 is a reply to message #406372]

Wed, 03 June 2009 13:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Re: Help Needed - to stop jobs [message #406376 is a reply to message #405980]

Wed, 03 June 2009 13:45

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

ok.may be i am wrong.Thanks

Report message to a moderator

Previous Topic:	ORACLE 10.2 not able to start listener (merged 3)
Next Topic:	SQL ID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:30:05 CST 2024