Re: How to execute the daily job?

By setting the job_queue_processes = 1 only tells Oracle to start a background process. You also need to set the job_queue_interval to some value. The value here is the number of seconds to "sleep" between checking for work. Try setting the "job_queue_interval=10" (for ten seconds)

Brian

§õÄ£©v wrote in message <34DBF585.6EF9745E_at_ms8.hinet.net>...
>Q1: I have a procedure, it import a text file into database, my
>plateform is Windows NT 4.0, database version is 7.2.2.4.
>
>Q2: I added the parameter "job_queue_processes=1" into initial file, and
>
>I restarted the database, but when I used the SQLDBA "SHOW PARAMETERS"
>to check, it showed "job_queue_processes=0". Is there somethings I loss
>?
>
>Thanks for help !
>
Received on Sat Feb 07 1998 - 00:00:00 CET