Making my firts job

Thu, 21 Aug 2003 16:24:00 -0700

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