Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP: How to stop a dbms job gracefully

HELP: How to stop a dbms job gracefully

From: Xuewei Zhou <zhou_at_Glue.umd.edu>
Date: 1996/11/08
Message-ID: <55vt89$rep@cm1.umd.edu>#1/1 







We have a problem with one of the jobs scheduled to run periodically
using DBMS_JOB packages. It shows up in dba_jobs_running but it is not
doing anything. We had to shutdown and restart the database to have
this job working again. If you know how to stop a running job, please
help. We are looking for a short term solution that can stop a hung job
and run it again at the next interval without shuting down the database
while we are working on the long term solution.



Thanks.



LuHuaron_at_usa.redcross.org
Received on Fri Nov 08 1996 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US