| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_jobs
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
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)))'
);
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
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
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: MacGregor, Ian A. INET: ian_at_SLAC.Stanford.EDU 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).Received on Fri Sep 07 2001 - 11:37:58 CDT
 |
 |