RE: Job to run first Wednesday

I repeat. I read 'em. if he sets the interval to the next_day function, and submits the job before the first Wednesday of the month IN THE SAME MONTH, it won't run the first Wednesday of that month

• Jared.Still_at_radisys.com wrote:
  > Rachel,
  >
  > The assumption is that the current day is already >= the first
  > wednesday
  > of the month,
  > making it useful for the dbms_job interval.
  >
  > Did you read the specs? :)
  >
  > Jared
  >
  >
  >
  >
  >
  >
  > Rachel Carmichael <wisernet100_at_yahoo.com>
  > Sent by: ml-errors_at_fatcity.com
  > 07/22/2003 01:14 PM
  > Please respond to ORACLE-L
  >
  >
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > cc:
  > Subject: RE: Job to run first Wednesday
  >
  >
  > don't rush off to use it..... I tried it, substituting August 1 and
  > got
  > September.
  >
  > 1* select
  > next_day(last_day(to_date('08/01/2003','MM/DD/YYYY')),'WED') from
  > dual
  > SQL> /
  >
  > NEXT_DAY(
  > ---------
  > 03-SEP-03
  >
  >
  > --- Jared.Still_at_radisys.com wrote:
  > > Hmm... much more elegant than mine, and everyone elses.
  > >
  > > Guess I better RTFM the next_day function.
  > >
  > >
  > >
  > >
  > >
  > >
  > > "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
  > > Sent by: ml-errors_at_fatcity.com
  > > 07/22/2003 12:34 PM
  > > Please respond to ORACLE-L
  > >
  > >
  > > To: Multiple recipients of list ORACLE-L
  > > <ORACLE-L_at_fatcity.com>
  > > cc:
  > > Subject: RE: Job to run first Wednesday
  > >
  > >
  > > Josh,
  > >
  > > With the following functions, you could probably get it to work:
  > >
  > > select next_day(last_Day(sysdate),'WED') from dual
  > >
  > > This (today) returns Wed, August 6th.
  > >
  > > Tom Mercadante
  > > Oracle Certified Professional
  > >
  > >
  > > -----Original Message-----
  > > Sent: Tuesday, July 22, 2003 3:14 PM
  > > To: Multiple recipients of list ORACLE-L
  > >
  > >
  > > Greetings,
  > >
  > > How can I set the interval in my dbms job to have it run on the
  > first
  > > Wednesday of every month? Is this even possible? I have been trying
  > > to
  > > noodle it thru for a week to no avail.
  > >
  > > tia,
  > >
  > > Josh
  > > --
  > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > > --
  > > Author: Josh Collier
  > > INET: Josh.Collier_at_Banfield.net
  > >
  > > 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: Mercadante, Thomas F
  > > INET: NDATFM_at_labor.state.ny.us
  > >
  > > 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).
  >
  >
  > __________________________________
  > Do you Yahoo!?
  > Yahoo! SiteBuilder - Free, easy-to-use web site design software
  > http://sitebuilder.yahoo.com
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author: Rachel Carmichael
  > INET: wisernet100_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:
  > 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).