RE: Making my firts job

Fri, 22 Aug 2003 05:08:58 -0700

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-----
From: Teresita Castro [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 8:15 PM
To: Multiple recipients of list ORACLE-L
Subject: 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='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?
 
 

Reply via email to