Thanks for answering
That's not what I'm looking for, I don't want to do it
with UNIX crontab.
I need to do it by using DBMS_JOB package !!!
- Scott.Shafer_at_dcpds.cpms.osd.mil escribió: > use
1-6 for every day except Sunday and
> 1-5 for every day except Saturday and Sunday.
> Days in cron are labelled 0-6, starting with Sunday,
> respectively.
>
> i.e.,
>
> 00 17 * * 1-6 /opt/oracle/admin/scripts/
> 00 17 * * 1-5 /opt/oracle/admin/scripts/
>
> --Scott Shafer
> San Antonio, TX
>
> > -----Original Message-----
> > From: Pablo ksksksk [SMTP:p_rodri99_at_yahoo.es]
> > Sent: Friday, March 02, 2001 8:51 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: DBMS_JOB -- urgent !!!
> >
> > Hi list,
> > I need to cron a job every day at 10pm except
> > sundays, how do I acomplish this ? I need the
> INTERVAL
> > field.
> >
> > I also need to cron another job every day
> except
> > sundays an saturdays too, can you please help me
> with
> > this?
> >
> > thanks in advance.
> >
> >
>
> > Do You Yahoo!?
> > Envía mensajes instantáneos y recibe alertas de
> correo con
> > Yahoo! Messenger - http://messenger.yahoo.es
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?Pablo=20ksksksk?=
> > INET: p_rodri99_at_yahoo.es
> >
> > 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).
Do You Yahoo!?
Envía mensajes instantáneos y recibe alertas de correo con
Yahoo! Messenger -
http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
INET: p_rodri99_at_yahoo.es
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 Mar 02 2001 - 12:45:07 CST