dbms_job.submit to execute every round hour (12am...11pm)

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/05/24
Message-ID: <392c50b1.109302803@news.earthlink.net>#1/1

I tried the following, but it doesn't seem to work.

variable v_job_num number;
execute dbms_job.submit(:v_job_num, 'dbmonitor.populate_sql_history;', sysdate, 'round(sysdate, ''hh'') + 1/24');

---

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Wed May 24 2000 - 00:00:00 CDT