Home » RDBMS Server » Server Administration » Oracle JOB (ORACLE 11gR2,RHEL 5)
Oracle JOB [message #588177] Sat, 22 June 2013 05:38 Go to next message
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
Dear ,

My job status is running, but when i want to stop the job with FORCE option, ORACLE through a below mention error.
Also when I query "select * from dba_jobs_running";
Oracle shows no job.

Please help me in this regards.

ORA-27366: job "REG.TRAN_SUMMARY_TODAY" is not running
ORA-06512: at "SYS.DBMS_ISCHED", line 199
ORA-06512: at "SYS.DBMS_SCHEDULER", line 557
ORA-06512: at line

Re: Oracle JOB [message #588178 is a reply to message #588177] Sat, 22 June 2013 08:09 Go to previous messageGo to next message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I believe that Oracle better reports reality than you do.

>My job status is running,
post SQL & results that show above is true.
Re: Oracle JOB [message #588180 is a reply to message #588177] Sat, 22 June 2013 09:40 Go to previous message
Michel Cadot
Messages: 68598
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not tell us what you (think you) do and see, show us: Use SQL*Plus and copy and paste your session, the WHOLE session.

But before, as said in your previous topic:

Michel Cadot wrote on Tue, 24 July 2012 08:13
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Previous Topic: Changing hostname
Next Topic: Don't have disk space when add data file on primary database
Goto Forum:

Current Time: Thu Feb 29 08:36:31 CST 2024