OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle JOB (ORACLE 11gR2,RHEL 5)

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

Oracle JOB [message #588177]

Sat, 22 June 2013 05:38

zeeshan007
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

Regards,
Zeeshan
DBA

Report message to a moderator

Re: Oracle JOB [message #588178 is a reply to message #588177]

Sat, 22 June 2013 08:09

BlackSwan
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.

Report message to a moderator

Re: Oracle JOB [message #588180 is a reply to message #588177]

Sat, 22 June 2013 09:40

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

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.
...

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 19:49:09 CDT 2025