Re: Prevent job from starting (dbms

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 18 Apr 2001 16:23:24 +0200
Message-ID: <lp8rdt8apdr4hut5361hbjssbi7qdslkdb@4ax.com>

On 18 Apr 2001 10:42:01 GMT, kristian.myllymaki3_at_e-techfactory.com wrote:

>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 Web -----
> 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

exec dbms_job.broken(<job_id>, true)

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Apr 18 2001 - 09:23:24 CDT

Re: Prevent job from starting (dbms_job)