HELP: How to stop a dbms job gracefully

From: Xuewei Zhou <zhou_at_Glue.umd.edu>
Date: 1996/11/08
Message-ID: <55vt89$rep_at_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 CET

This message: [ Message body ]
Next message: Alvin Sylvain: "Limiting Rows Returned in Query"
Previous message: David Perez: "Re: NT and Designer/2000"
Next in thread: Manoj Appully: "Re: HELP: How to stop a dbms job gracefully"
Reply: Sten E. Vesterli: "Re: HELP: How to stop a dbms job gracefully"
Reply: Lun Wing San (Oracle): "Re: HELP: How to stop a dbms job gracefully"
Reply: Xuewei Zhou: "Re: HELP: How to stop a dbms job gracefully"
Reply: Manoj Appully: "Re: HELP: How to stop a dbms job gracefully"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message