Home » SQL & PL/SQL » SQL & PL/SQL » Job
Job [message #38870] Thu, 23 May 2002 05:03 Go to next message
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 Go to previous message
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.
Previous Topic: Creating Users and allowing them access to your tables or objects
Next Topic: Sequential Numbering
Goto Forum:
  


Current Time: Thu Mar 28 08:59:10 CDT 2024