RE: DBMS

From: Ramon Estevez <com.banilejas_at_codetel.net.do>
Date: Mon, 02 Jul 2001 08:51:23 -0700
Message-ID: <F001.0033F2B4.20010702075033@fatcity.com>

Thanks again to all that reply

I used the procedure run of the package DBMS_JOB to reexecute my jobs and they rescheduled with the correct dates again

DMBS_JOB.RUN(JOB_NUMBER) tks

Ramon Estevez

*809-565-3121 x 225

com.banilejas_at_codetel.net.do

-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de Ramon Estevez Enviado el: Monday, 02 July, 2001 9:01 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: DBMS_JOB

Thanks to all that reply,

I want to clean the queue, erase to the jobs, and reschedule them again

Ramon Estevez

*809-565-3121 x 225

com.banilejas_at_codetel.net.do

-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de A. Bardeen Enviado el: Monday, 02 July, 2001 3:50 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: DBMS_JOB

Ramon,

When a job is broken the next_date is set to 01/01/4000.

I'm not sure I understand exactly what your initial request was, but you can alter the next_date and interval for any job using DBMS_JOB.CHANGE (or by calling DBMS_JOB.NEXT_DATE and DBMS_JOB.INTERVAL individually).

For examples of specifying different intervals, see Note: 1068369.6 "Example: Using DBMS_JOB.SUBMIT to Execute Jobs at Regular Intervals"

HTH,

Anita
- Raymond Lee Meng Hong <RAYMOND_at_infopro.com.my> wrote:
  > If order to stop those funny date , can you show me
  > the code of your pl/sql
  > and let us try to solve it ? Becoz it seen you try
  > to add in those error
  > date into your next_date ?
  >
  > You might need to create a lookup table to key in
  > those require date,and let
  > it parse to the procedure automatical..
  >
  >
  >
  > -----Original Message-----
  > Sent: Saturday, June 30, 2001 6:41 AM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > Thanks Ray and Dick,
  >
  > This the output, obviously some mistakes(*), how do
  > I stop them from
  > executing, (take them out)
  >
  > LAST_DATE NEXT_DATE
  > ---------- ----------
  > carga_d 29/06/2001 30/06/2001
  > mueve_h_f 20/02/2001 01/01/4000*
  > carga_d 29/06/2001 30/06/2001
  > carga_v_fl 29/06/2001 06/07/2001
  > carga_v_fl 14/03/2001 01/01/4000*
  > carga_v_f_s 29/06/2001 06/07/2001
  > carga_v_f_m 05/06/2001 05/07/2001
  > carga_d 20/03/2001 01/01/4000*
  > carga_d 19/03/2001 01/01/4000*
  > carga_s 20/03/2001 01/01/4000*
  > carga_v 20/03/2001 01/01/4000*
  > mueve_h 29/06/2001 30/06/2001
  > carga_s 29/06/2001 30/06/2001
  > carga_v 29/06/2001 30/06/2001
  > carga_h 29/06/2001 30/06/2001
  > mueve_h 29/06/2001 30/06/2001
  > carga_v_fl 29/06/2001 06/07/2001
  > carga_v_fl 02/07/2001
  >
  > What is the sintax
  > to execute the procedures, some every day, some
  > every week
  > and some two times a week, passing different dates
  > automatically as a
  > parameter.
  >
  > Thanks,
  >
  >
  > Ramon Estevez
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Ramon Estevez
  > INET: com.banilejas_at_codetel.net.do
  >
  > 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: Raymond Lee Meng Hong
  > INET: RAYMOND_at_infopro.com.my
  >
  > 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!?
Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.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: Ramon Estevez
  INET: com.banilejas_at_codetel.net.do

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: Ramon Estevez
  INET: com.banilejas_at_codetel.net.do

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 Mon Jul 02 2001 - 10:51:23 CDT