Re: dbms_jobs

On Monday 10 September 2001 06:35, Christopher Spence wrote:
> >Less keystrokes, yes, but the long version is less likely
> >to generate questions like 'What do those numbers mean?' :)
>
> There in the books :)

Geez Chris, of course they're in the books. That doesn't stop people from asking. :)

After a few years of this you learn how to head off many of the inevitable RTFM questions.

Jared

>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax: (707) 885-2275
>
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
>
>
>
> -----Original Message-----
> Sent: Sunday, September 09, 2001 3:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Less keystrokes, yes, but the long version is less likely
> to generate questions like 'What do those numbers mean?' :)
>
> Other jobs running on the database is not really a factor in the timing of
> my test, as there are no other jobs in the database, and I am the only user
> of the entire box.
>
> Jared
>
> On Friday 07 September 2001 10:21, MacGregor, Ian A. wrote:
> > I find it easier, takes less keystrokes, I am the world's worst
> > typist, to SCHEDULE A JOB TO RUN AT 9:45 pm and run every five
> > minutes thereafter
> >
> > exec dbms_job.submit(:<jobno>,'<procedure>;', trunc(sysdate) +
> > 21.75/24,
> > 'trunc(sysdate,''MI'') + 5/1440')
> >
> > Also bear in mind the job_queue_interval parameter and the number of
> > job queue procceses running. There's no guarantee the job will start
> > precisely when it is scheduled.
> >
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > ian_at_slac.stanford.edu
> >
> > -----Original Message-----
> > Sent: Thursday, September 06, 2001 11:00 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Any thoughts on how this was scheduled this way?
> >
> > Schedule a job that takes 10 minutes, set the interval
> > to run 5 minutes after the first job starts.
> >
> > Here's the job:
> >
> > create or replace procedure dummy
> > is
> > begin
> > -- sleep for 10 minutes
> > -- envy the computer
> > -- waiting for interruption
> > dbms_lock.sleep(10*60);
> > end;
> > /
> >
> > Here's the submission:
> >
> > declare
> > jobno integer;
> > begin
> > dbms_job.submit(
> > job => jobno
> > , what => 'dummy;'
> > -- provide resolution to the second
> > -- midnight hour of minute of units
> > per day -- of current day day to run hr to run ( 1
> > second ) , next_date => trunc(sysdate) + ((21 * (60*60) + ( 60*45)) *
> > (
> > 1/(60*60*24))) , interval => 'trunc(sysdate) + ((21 * (60*60) + ( 60*50))
>
> *
>
> > ( 1/(60*60*24)))' );
> > commit;
> > end;
> > /
> >
> > Here's before it ran:
> > FAIL
> > SCHEMA_USE PRIV_USER LOG_USER JOB LAST_DATE LAST_SEC
> > NEXT_DATE NEXT_SEC TOTAL_TIME B INTERVAL URES WHAT
> > ---------- ---------- ---------- ------ ------------------- --------
> > ------------------- -------- ---------- - -------------------- ----
> > --------------------
> > JKSTILL JKSTILL JKSTILL 22
> > 09/06/2001 21:45:00 21:45:00 244 N trunc(sysdate) + ((2 dummy;
> >
> > 1 * (60*60) + ( 60*5
> >
> > 0)) * ( 1/(60*60*24)
> >
> > ))
> >
> >
> > Here's after it ran:
> >
> > FAIL
> > SCHEMA_USE PRIV_USER LOG_USER JOB LAST_DATE LAST_SEC
> > NEXT_DATE NEXT_SEC TOTAL_TIME B INTERVAL URES WHAT
> > ---------- ---------- ---------- ------ ------------------- --------
> > ------------------- -------- ---------- - -------------------- ----
> > --------------------
> > JKSTILL JKSTILL JKSTILL 22 09/06/2001 21:45:14 21:45:14
> > 09/06/2001 21:57:28 21:57:28 614 N trunc(sysdate) + ((2 1
> > dummy;
> >
> > 1 * (60*60) + ( 60*5
> >
> > 0)) * ( 1/(60*60*24)
> >
> > ))
> >
> > Notice the next run time is 00:02:28 after completion of the first
> > job.
> >
> > Jared
> >
> > On Thursday 06 September 2001 00:50, nlzanen1_at_EY.NL wrote:
> > > Hi
> > >
> > >
> > > As far as I know the job will be rescheduled after the job
> > > completes. So in your examples the job will start one hour after the
> > > two hour job finishes.
> > >
> > >
> > > Jack
> > >
> > >
> > >
> > >
> > > David Turner <turner_at_tellme.com>@fatcity.com on 06-09-2001 05:35:32
> > >
> > > Please respond to ORACLE-L_at_fatcity.com
> > >
> > > Sent by: root_at_fatcity.com
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
> > >
> > > I was wondering if you schedule a job to run every hour and say the
> > > job takes 2 hours to run. Will the next run of the job queue up or
> > > will it run in parallel with the current job? I'll be testing this
> > > but if anyone knows I would appreciate it?
> > >
> > > Also if the second job waits for the first job to finish how can you
> > > see how many jobs have queued up?
> > >
> > > Thanks, Dave
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: David Turner
> > > INET: turner_at_tellme.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > > name of mailing list you want to be removed from). You may also
> > > send the HELP command for other information (like subscribing).
> > >
> > >
> > >
> > >
> > > ====================================================================
> > > =
> > > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> > > uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> > > vermenigvuldiging, verspreiding en/of verstrekking van deze informatie
> > > aan derden is, behoudens voorafgaande schriftelijke toestemming van
>
> Ernst
>
> > > & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> > > volledige overbrenging van de inhoud van een verzonden e-mailbericht,
> > > noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen
> > > dat een verzonden e-mailbericht vrij is van virussen, noch dat
> > > e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van
> > > onbevoegde derden.
> > >
> > > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken
> > > wij u vriendelijk doch dringend het e-mailbericht te retourneren aan
> > > de verzender en het origineel en eventuele kopiekn te verwijderen en
> > > te vernietigen.
> > >
> > > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden
> > > algemene voorwaarden, waarin een beperking van aansprakelijkheid is
> > > opgenomen. De algemene voorwaarden worden u op verzoek kosteloos
> > > toegezonden.
> > > =====================================================================
> > > The information contained in this communication is confidential and is
> > > intended solely for the use of the individual or entity to whom it is
> > > addressed. You should not copy, disclose or distribute this
>
> communication
>
> > > without the authority of Ernst & Young. Ernst & Young is neither liable
> > > for the proper and complete transmission of the information contained
> > > in this communication nor for any delay in its receipt. Ernst & Young
> > > does not guarantee that the integrity of this communication has been
> > > maintained nor that the communication is free of viruses, interceptions
> > > or interference.
> > >
> > > If you are not the intended recipient of this communication please
> > > return the communication to the sender and delete and destroy all
> > > copies.
> > >
> > > In carrying out its engagements, Ernst & Young applies general terms
> > > and conditions, which contain a clause that limits its liability. A
> > > copy of these terms and conditions is available on request free of
> > > charge.
> > > ====================================================================
> > > =

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).