Re: How to find what dbms_job is executing

I tried it deleting the current job : But it just kept causing the job to terminate badly and be reexecuted in 10 secs time.....!

On Wed, 20 Jan 1999 17:08:23 +0000, Andy Hardy <Andy.Hardy_at_camk.demon.co.uk> wrote:

>In article <36a5d38f.96978888_at_news.demon.co.uk>, Chris Selwyn
><selwync_at_stc.com> writes
>>Dear All,
>>
>>I would like to find out in a trigger function whether a job I am
>>about to delete is currently executing. (If it is then I don't want to
>>delete it!)
>>
>>The documentation says that user_jobs.this_date is 'Date that this
>>job started executing (usually null if not executing) '.
>>
>>I am slightly worried by the 'usually' - Could someone explain?
>>
>>
>>Chris Selwyn
>>STC (UK) Ltd.
>Dunno...
>
>Check dba_jobs_running to see what jobs are currently running.
>
>Why don't you want to try and delete a running job? Oracle won't let you
>delete if it is running.
>
>Andy

Chris Selwyn
STC (UK) Ltd. Received on Wed Jan 20 1999 - 11:18:05 CST