Re: dbms_job - running jobs every 15 minutes

Well, I did consider that using 4 jobs , but my overdeveloped sense of aesthetics and professional hubris (that one mostly) required that it be done with a single job. ;)

Lots of good suggestions here.

Seems like everyone is always up for a puzzle. :)

Jared

"Arup Nanda" <arupnanda_at_hotmail.com>
Sent by: root_at_fatcity.com
 01/22/2003 06:54 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: dbms_job - running jobs every 15 minutes

That's exactly what I do. Phew! I thought I was the only one ;)

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 22, 2003 8:03 AM

> Personally, I tend to just submit four jobs: one at the top of hour,
one
at
> 15 past, one at 30 past, and the fourth at 45 past. To alter the
frequency,
> just "break" or remove one or more of the jobs. Falls into the category
of
> "not elegant, but it works"...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, January 21, 2003 9:39 PM
>
>
> > How about this... this will start the job at the top of the following
hour
> > and then schedule it every 15 minutes...
> >
> > dbms_job.submit(:jobno,
> > 'statspack.snap;',to_date(to_char(sysdate+60/1440,'mm/dd/yyyy hh24'),
> > 'mm/dd/yyyy hh24') ,'to_date(to_char(sysdate+60/1440,''mm/dd/yyyy
hh24''),
> > ''mm/dd/yyyy hh24'') + 15/1440' );
> >
> >
> > -----Original Message-----
> > Jared.Still_at_radisys.com
> > Sent: Tuesday, January 21, 2003 6:24 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Feeling particularly anal the other day, I used the following
> > specification to
> > run statspack at the top of the hour, 15, 30 and 45 minutes after the
> > hour.
> >
> > variable jobno number;
> > variable instno number;
> > begin
> > select instance_number into :instno from v$instance;
> > dbms_job.submit(
> > :jobno
> > , 'statspack.snap;'
> > -- every 15 minutes at 00,15,30 and 45
> > , trunc(sysdate,'hh24') + ( ( 15 + ( 15 *
> > floor(to_number(to_char(sysdate,'mi')) / 15))) / ( 24 * 60 ))
> > , 'trunc(sysdate,''hh24'') + ( ( 15 + ( 15 *
> > floor(to_number(to_char(sysdate,''mi'')) / 15))) / ( 24 * 60 ))'
> > );
> > commit;
> > end;
> > /
> >
> >
> > Seems to me that the time specs could be simplified a bit.
> >
> > Anyone care to give it a go? :)
> >
> > Jared
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> > INET: Jared.Still_at_radisys.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> > --
> > Author: Robert Freeman
> > INET: robertgfreeman_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: Tim Gorman
> INET: Tim_at_SageLogix.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).