| 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
|
|
|
|
|
|
| Re: Oracle JOB [message #588180 is a reply to message #588177] |
Sat, 22 June 2013 09:40  |
 |
Michel Cadot
Messages: 68641
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.
...
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
