RE: Job to run first Wednesday

I did. he said " I want to submit a job to run the first Wednesday of the month"

if he submits it the first time on August 1, it won't run until September

• "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us> wrote:
  > Rachel,
  >
  > Yeah, Sept 3 is the first Wednesday of September (the next month).
  > You
  > gotta read the memos.... :)
  >
  > Tom Mercadante
  > Oracle Certified Professional
  >
  >
  > -----Original Message-----
  > Sent: Tuesday, July 22, 2003 4:15 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > 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: 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).