RE: Making my firts job

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)

>>> JohnF_at_smdi.com 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-----
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: Teresita Castro
  INET: Teresita.Castro_at_s-martmx.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).