DBMS_JOB.SUBMIT ?

From: <dishan_at_gmail.com>
Date: 6 Nov 2006 02:22:17 -0800
Message-ID: <1162808537.263845.88310@e3g2000cwe.googlegroups.com>

Hi,
This is the job that schedule to run at every night 23:58pm. Can anybody please check the INTERVAL is correct or NOT.?

---

declare v_JobNum NUMBER;

BEGIN   DBMS_JOB.SUBMIT(

  	v_JobNum,


  	'BEGIN UPDHITCOUNT(); END;',

  	TRUNC(SYSDATE),


  	'TRUNC(SYSDATE) + ((24*60*60 - 180)/(24*60*60))' -- 23:58

  	);

  dbms_output.put_line(v_JobNum);

END;

---

Thanks in advance

Dishan Received on Mon Nov 06 2006 - 04:22:17 CST