Home » SQL & PL/SQL » SQL & PL/SQL » How to stop a running job (Oracle 11g,Win XP)
How to stop a running job [message #405724] Fri, 29 May 2009 04:11 Go to next message
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
Re: How to stop a running job [message #405727 is a reply to message #405724] Fri, 29 May 2009 04:14 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Have a look at this.

By
Vamsi
Re: How to stop a running job [message #405728 is a reply to message #405724] Fri, 29 May 2009 04:16 Go to previous messageGo to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
http://www.psoug.org/reference/OLD/dbms_job.html?PHPSESSID=c92c4adacd9f07035478f3e0b5370ab1
Re: How to stop a running job [message #405729 is a reply to message #405724] Fri, 29 May 2009 04:17 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Thanks Vamsi, I will look into this Smile
Re: How to stop a running job [message #405736 is a reply to message #405729] Fri, 29 May 2009 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And throw away TOAD and use SQL*Plus.

Regards
Michel
Re: How to stop a running job [message #405738 is a reply to message #405724] Fri, 29 May 2009 04:43 Go to previous message
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.
Previous Topic: using Dbms_Job to call the procedure
Next Topic: How to extract the left and right sides of the decimal
Goto Forum:
  


Current Time: Mon Nov 04 11:27:17 CST 2024