Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_job.submit to execute every round hour (12am...11pm)

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

From: Doug Cowles <dcowles_at_i84.net>
Date: 2000/05/25
Message-ID: <392c7bd1.1545031@news.remarq.com>#1/1

I had no problem with this (with a different procedure)... what's the issue? The only thing I could think of is that you might have actual double quotes around hh which could cause a problem. Other than that, do you have an background processes running to execute the job? job_queue_processes
job_queue_interval

?

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
Received on Thu May 25 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US