Home » RDBMS Server » Server Administration » DBMS_JOB
DBMS_JOB [message #136162] Tue, 06 September 2005 08:14 Go to next message
SaraC
Messages: 81
Registered: August 2005
Member
Hi can anyone help

I have submitted an Oracle job using DBMS_JOB.SUBMIT(..) but the job does not run. The code I want to run as a job has updates to tables so I know they are not happening.

I can run the job manually using DBMS_JOB.RUN(..) and the tables are updated but doesnt seem to work on the SUBMIT .

Any ideas why this is not working. The package with the code is owned by the user trying to subnmit/create the job if thats any help...

Thanks
Sara

Report message to a moderator

Re: DBMS_JOB [message #136206 is a reply to message #136162] Tue, 06 September 2005 13:23 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Have you set the JOB_QUEUE_PROCESSES parameter to a value of 1 or higher?

Best regards.

Frank

Report message to a moderator

Re: DBMS_JOB [message #136226 is a reply to message #136162] Tue, 06 September 2005 15:40 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Did you COMMIT? DBMS_JOB.SUBMIT won't fire unless and until you COMMIT.

Report message to a moderator

Re: DBMS_JOB [message #136270 is a reply to message #136162] Wed, 07 September 2005 03:43 Go to previous message
SaraC
Messages: 81
Registered: August 2005
Member
Thanks for the advice.

I found the problem but forgot to post the solution up. You were right Frank - the JOB_QUEUE_PROCESSES was set to 0.

Thanks for replying anyway!

Report message to a moderator

Previous Topic: How To Know If Oracle Is RollBacking
Next Topic: Patching Oracle 8i Enterprise Edition from 8.1.7.0 to 8.1.7.4
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 10:50:00 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.