Re: How to find what dbms_job is executing

From: Andy Hardy <Andy.Hardy_at_camk.demon.co.uk>
Date: Wed, 20 Jan 1999 17:08:23 +0000
Message-ID: <mgCXXOAH2gp2Mw+i@camk.demon.co.uk>

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
--
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 Wed Jan 20 1999 - 11:08:23 CST