Re: Prevent job from starting (dbms

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 18 Apr 2001 13:22:01 GMT
Message-ID: <ZxgD6.25818$xN4.1796847@news1.sttls1.wa.home.com>

You could have the job look and see if the previous job is still in the dba_jobs_running table (I may have the table name wrong). If it is then you could sleep and recheck or exit.
Jim

<kristian.myllymaki3_at_e-techfactory.com> wrote in message news:9bjr1p$vl$1_at_news.netmar.com...
> Hi,
>
> How can i prevent a job from starting if the prevoius job is still
running?
>
> My jobs are submitted via dbms_job.
>
> Thanx,
> -Chris
>
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
eb -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email
abuse_at_newsone.net Received on Wed Apr 18 2001 - 08:22:01 CDT

Re: Prevent job from starting (dbms_job)