Job [message #38870] |
Thu, 23 May 2002 05:03 |
Fred
Messages: 34 Registered: August 1999
|
Member |
|
|
Hi!!!
I´m having some trouble with a job. When I manually execute it (BEGIN dbms_job.run(JobNo); END;) it runs perfectly, but when the job tries to execute automatically whithin the interval I set, it fails.
Where can I see a log or sth that tells me why it´s failing.
Thanks a lot!
F
|
|
|
Re: Job [message #38902 is a reply to message #38870] |
Fri, 24 May 2002 12:45 |
Kevin Gao
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
Have you set up the parameters in init.ora properly?
i.e.:
job_queue_interval = 60 (in seconds)
job_queue_processes = 1 (at least one)
Then bunce the database and it should work.
|
|
|