Re: HELP: How to stop a dbms job gracefully

Xuewei Zhou wrote:
>
> 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.How does the database respond if you manually mark the job as broken using
DBMS_JOB.BROKEN? The DBA_JOBS_RUNNING shows the session id of the running job. My guess would be that the job will have its own session that can be killed with session manager?

When you find an answer, please post it.

Best regards and good luck,

Sten Vesterli
Systems Engineer
TPI - Tom Pedersen International A/S
sev_at_tpi.dk Received on Sat Nov 09 1996 - 00:00:00 CST