Re: How to find what dbms_job is executing

From: Maija-Leena Kangasmäki <maija-leena.kangasmaki_at_tieto.com>
Date: Mon, 25 Jan 1999 07:09:13 GMT
Message-ID: <36AC1855.3BB36292@tieto.com>

I don't know what the original problem was but you can find out which jobs are running from dba_jobs_running -view.

Maija-Leena

Andy Hardy wrote:

> In article <36a70f87.112331223_at_news.demon.co.uk>, Chris Selwyn
> <selwync_at_stc.com> writes
> >I tried it deleting the current job : But it just kept causing the
> >job to terminate badly and be reexecuted in 10 secs time.....!
>
> That's interesting... I expected the delete to hang until the job
> completed, in the same way as recompiling the procedure would hang.
>
> Andy
> --
> Andy Hardy
> Senior IT Systems Engineer, Alstom Automation
> Tel: +44 1908 696200
> Fax: +44 1908 696225
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Opinions are mine and do not necessarily reflect those of Alstom Automation
Received on Mon Jan 25 1999 - 01:09:13 CST