Home » RDBMS Server » Enterprise Manager » Job status : stop pending for over 2 months .... (Oracle 10.2, Windows 2003 in cluster mode.)
Job status : stop pending for over 2 months .... [message #342037] Thu, 21 August 2008 02:39 Go to next message
pollus
Messages: 3
Registered: August 2008
Location: Poland
Junior Member
Good morning,

I have been having a problem with Oracle. Some of jobs do not want to stop, once I press Stop button it says " The job was stopped successfully" but it goes into stop pending status and stays there for ages, once I want to delete it it says that the job must be stopped first before I can be deleted.
Any idea hot to stop it ? I tried almost everything I spent ages googling there is no information about this problem only solution is " press stop and then delete... " yeah does not work for me though.

Regards,

Paul
Re: Job status : stop pending for over 2 months .... [message #342042 is a reply to message #342037] Thu, 21 August 2008 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which job? Which stop button? There is no one on my desktop.

Regards
Michel
Re: Job status : stop pending for over 2 months .... [message #342043 is a reply to message #342037] Thu, 21 August 2008 02:50 Go to previous messageGo to next message
pollus
Messages: 3
Registered: August 2008
Location: Poland
Junior Member
In Enterprise manager, after you got o jobs choose the job that you want to stop edit it and there is a "stop" button. After you press it it goes round to " stop pending" then you want to delete it but it cannon be deleted untill it is fully stopped... any ideas ?

thanks
Re: Job status : stop pending for over 2 months .... [message #342048 is a reply to message #342043] Thu, 21 August 2008 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So this is an EM question, I move the topic to the correct forum.

Regards
Michel
Re: Job status : stop pending for over 2 months .... [message #342051 is a reply to message #342037] Thu, 21 August 2008 03:20 Go to previous messageGo to next message
pollus
Messages: 3
Registered: August 2008
Location: Poland
Junior Member
To be honest it is not EM question, there is no problem with the Em the problem is with the Oracle itself... but thanks for your reply
Re: Job status : stop pending for over 2 months .... [message #342097 is a reply to message #342051] Thu, 21 August 2008 05:56 Go to previous message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi,
try the following script which is on metalink

Edit MC: Copyrighted material removed, post Metalink note and not its content


this will give information about the job then try

mgmt_job_engine.stop_all_executions_with_id(jobid,TRUE);

regards

Alan

[Updated on: Thu, 21 August 2008 06:55] by Moderator

Report message to a moderator

Previous Topic: dbconsole after restore on new host
Next Topic: starting enterprise manager
Goto Forum:
  


Current Time: Thu Mar 28 09:37:44 CDT 2024