Hi
I have some job which is available in dba_jobs_running but it is not
available in dba_jobs
How can I remove these job?
Thx
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official
dbms_job.remove(job#); (AS the owner of the job)
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Wednesday, May 30, 2001 4:59 PM
To: Multiple recipients of list ORACLE-L
Bismillah
Hi Seema !
Any Jobs in DBA_JOBS_RUNNING Shows the jobs which are
currently being run by oracle.
To remove these enteries you have to kill the sessions
which are running those jobs manually using :
alter system kill session 'sid,serial#';
Hope it help you.
Regards
Your DBA
Salman
Hi Christopher !
dbms_job.remove (job#) Remove an existing job from
the job queue.But it does not stop a job if it is
currently running.
Comments !
Best Regards
Your DBA
Salman Faheem
--- Christopher Spence [EMAIL PROTECTED] wrote:
dbms_job.remove(job#); (AS the owner of the job
Oh, I don't think I saw that part.
Find the sid from dba_jobs_running and alter system kill session or kill
the unix process.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/30/01 8:15 PM
Hi Christopher !
dbms_job.remove (job#) Remove an existing job from