RE: Making my firts job

Simple: TRUNC(SYSDATE) + 1 + 1/60/60/24  

TRUNC(SYSDATE) is midnight today.
+1 is midnight tomorrow.
+1/60/60/24 is one second past midnight - 1/60th of a minute, which is 1/60th of an hour, which is 1/24th of a day.

-----Original Message-----
Sent: Thursday, August 21, 2003 8:15 PM
To: Multiple recipients of list ORACLE-L

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='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?    

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