Re: Job queue Question

I'll try!

Ok open the init.ora or inst.ora file(which is applicable to your database version) and see whether the following entry is there:

job_queue_processes=(something)

and

job_queue_interval=(something)

if they are not there in the init.ora or inst.ora file then add them as

job_queue_proecesses=2

job_queue_interval=3

save this file and then close and restart the database.

AS for the other part I think that your dbms_job.submit is wrong make correction if you want to run it every 6 pm:

dbms_job.submit(:v_jobnum,'tempinsert;',sysdate,'trunc(sysdate)+3/4');

run this script and then come to the sql prompt and then type

print v_jobnum

it should display a job number

I think this will solve the problem.....

Note in the above submit which i wrote tempinsert is any procedure name

and v_jobnum is out parameter;

if the problem is not solved let me know bye....

amerar_at_ci.chi.il.us wrote in message <7m09v5$m3u$1_at_nnrp1.deja.com>...
>
>
>
>Hello,
>
>I put a job into the job queue with this command:
>
>VARIABLE jobno number;
>begin
> DBMS_JOB.SUBMIT(:jobno,
> 'cash_man.water_pull;',
> sysdate,
> 'sysdate + 18/24');
> commit;
>end;
>/
>
>I want the job to run everyday at 6:00pm.......this is not happening.
>Can someone help me out with the interval??
>
>Please cc a copy to email....
>
>Thanks,
>
>Arthur
>amerar_at_ci.chi.il.us
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jul 13 1999 - 00:25:46 CDT