RE: Making my firts job

>Hi!!
>I am making my firts job and I have some problems
>calculating the correct =
>time to lauch the job.
>I have the next procedure:
>
>CREATE OR REPLACE PROCEDURE SP_SOH_HAND
>AS
>BEGIN
>INSERT INTO TB_ICTRANSX select COMPANY,
>LOCATION,ITEM,SOH_QTY,AVERAGE_COST,=
> SYSDATE-1, UPDATE_TIME from iTEMLOC where
>TRACKING_FL=3D'Y';
>COMMIT;
>END SP_SOH_HAND;
>/
>
>This procedure will feed a table every day, I want
>this to happen after =
>midnight, on the first second of the next day,
>every day. How can I create =
>a job to do that?

Teresita,

   Just read $ORACLE_HOME/rdbms/admin/dbmsjob.sql, comments (which used to be inexact) explain fairly well how to do it. The interval you need is 'trunc(sysdate) + 1'. And don't forget to check that parameter job_processes is > 0 (I even prefer > 1).

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.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).