RE: dbms_jobs

>Less keystrokes, yes, but the long version is less likely
>to generate questions like 'What do those numbers mean?' :)

There in the books :)

"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 kopieën 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: cspence_at_FuelSpot.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).