Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find what dbms_job is executing
If you're a DBA!
On Mon, 25 Jan 1999 07:09:13 GMT, "Maija-Leena Kangasmäki" <maija-leena.kangasmaki_at_tieto.com> wrote:
>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
>
>
Chris Selwyn
STC (UK) Ltd.
Received on Mon Jan 25 1999 - 06:02:27 CST