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

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

Yes, I know.. commit!

On Wed, 24 May 2000 21:52:28 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>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

---

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