Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_job.submit to execute every round hour (12am...11pm)
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