OraFAQ Forum: SQL & PL/SQL » How to stop a running job

Home » SQL & PL/SQL » SQL & PL/SQL » How to stop a running job (Oracle 11g,Win XP)

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

How to stop a running job [message #405724]

Fri, 29 May 2009 04:11

ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore

Senior Member

Hi,

I have scheduled some jobs ( i use TOAD). When i run the following query it is not showing all the jobs i have created. Can you please suggest whether it is the right SQL

select * from user_jobs

And also how do i Stop the running jobs, Do i need to use DBMS_JOB.STOP_JOB or something else ?

Regards,
Ashoka BL

Report message to a moderator

Re: How to stop a running job [message #405727 is a reply to message #405724]

Fri, 29 May 2009 04:14

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Have a look at this.

By
Vamsi

Report message to a moderator

Re: How to stop a running job [message #405728 is a reply to message #405724]

Fri, 29 May 2009 04:16

prachij593
Messages: 266
Registered: May 2009

Senior Member

http://www.psoug.org/reference/OLD/dbms_job.html?PHPSESSID=c92c4adacd9f07035478f3e0b5370ab1

Report message to a moderator

Re: How to stop a running job [message #405729 is a reply to message #405724]

Fri, 29 May 2009 04:17

ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore

Senior Member

Thanks Vamsi, I will look into this Smile

Report message to a moderator

Re: How to stop a running job [message #405736 is a reply to message #405729]

Fri, 29 May 2009 04:41

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

Senior Member
Account Moderator

And throw away TOAD and use SQL*Plus.

Regards
Michel

Report message to a moderator

Re: How to stop a running job [message #405738 is a reply to message #405724]

Fri, 29 May 2009 04:43

ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore

Senior Member

Sure Michel , i shall do that, i am kind of accostomed to it, but I will not learn the basic things if we use tools.

Report message to a moderator

Previous Topic:	using Dbms_Job to call the procedure
Next Topic:	How to extract the left and right sides of the decimal

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 13 23:36:43 CST 2025