RE: Making my firts job

[Teresita Castro]

Thanks  !! A friend of mine give an example of how to do a procedure that runs a job:   CREATE OR REPLACE PROCEDURE lanza_job IS     jobno number;   instno number;    begin       dbms_job.submit( jobno, 'SP_SOH_HAND;', TRUNC(SYSDATE) + 1/60/60/24 ,'TRUNC(SYSDATE) + 1 + 1/60/60/24 ');    commit;   END lanza_job;   After add the start and end date I want to ask you if this procedure is correct. I want the job to start today and continue runs every single day.   Thanks a lot for your help, I am learning so much been in this list.   ( I hope you understand my English) >>> [EMAIL PROTECTED] 08/22/03 07:04AM >>> 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?