Home » RDBMS Server » Server Administration » oracle job submits but does not execute
oracle job submits but does not execute [message #60916] Fri, 12 March 2004 11:44 Go to next message
bechir
Messages: 23
Registered: November 2001
Junior Member
I submitted a job to execute a procedure but it didn't run. the next date is set to a future time. I can see the job in the dba_jobs but it does not execute at all. However, it does execute when I run it immediately using dbms_job.run(jobid).

do you have any idea why this is happening?

we are running oracle9i on aix.

Thanks

Report message to a moderator

Re: oracle job submits but does not execute [message #60924 is a reply to message #60916] Sat, 13 March 2004 23:37 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Set JOB_QUEUE_PROCESSES to a value greater than 0 in
your INIT.ORA file (or SPFile) and restart the
database.

Best regards.

Frank

Report message to a moderator

Previous Topic: urgent/how to open database at any case .reselogs.
Next Topic: I want to disable connection with "connect / as sysdba"
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:38:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.