Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Prevent job from starting (dbms job)

Re: Prevent job from starting (dbms job)

From: Marc Billiet <first.last_at_com.hydro.switch.this>
Date: Thu, 19 Apr 2001 05:55:13 GMT
Message-ID: <20010419.5551308@y1032960.hae.hydro.com>

If you're talking about the same job, you don't have to worry : a specific job always runs only once at the same time. If a job is scheduled to run every 5 minutes, and execution time is 6 minutes, the

second will run as soon as the first has stopped. If you're talking about different jobs which shouldn't run together, you  

could e.g. use dbms lock to create a user-lock, or check dba jobs running.

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2001-04-18, 12:42:01, schreef kristian.myllymaki3_at_e-techfactory.com

over het thema Prevent job from starting (dbms job):

> 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 W
eb



> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
 

groups
> NewsOne.Net prohibits users from posting spam. If this or other po
 sts
> made through NewsOne.Net violate posting guidelines, email
abuse_at_newsone.net Received on Thu Apr 19 2001 - 00:55:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US