Home » SQL & PL/SQL » SQL & PL/SQL » DBMS job (Oracle 9.2)
DBMS job [message #380917] Wed, 14 January 2009 01:02 Go to next message
shaksing
Messages: 115
Registered: November 2008
Senior Member
Please tell me the difference of creating a dbms job and submitting a job..

I encountered some of the commands like

DBMS_JOB.SUBMIT
DBMS_SCHEDULER.CREATE_JOB

Can anybody be able to explain the difference between the two.

Thanks
shaksing

[Updated on: Wed, 14 January 2009 01:02]

Report message to a moderator

Re: DBMS job [message #380918 is a reply to message #380917] Wed, 14 January 2009 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Too long to be explain in a forum. The only relation is that both allow you to asynchroneously execute something but not the same thing not in the same way not with the same objects not...
Refer to the documentation.

Regards
Michel
Re: DBMS job [message #380919 is a reply to message #380917] Wed, 14 January 2009 01:20 Go to previous messageGo to next message
v.ram81
Messages: 50
Registered: April 2006
Location: pune
Member

Hi,
DBMS_JOB and DBMS_SCHEDULER are both different built in packages.

Have a look at following links.

DBMS_JOB

DBMS_SCHEDULER

DBMS_SCHEDULER is available from 10g .
Regards,
Ram.

[Updated on: Wed, 14 January 2009 01:24]

Report message to a moderator

Re: DBMS job [message #380926 is a reply to message #380917] Wed, 14 January 2009 02:45 Go to previous messageGo to next message
shaksing
Messages: 115
Registered: November 2008
Senior Member
So if i have Oracle 9i , i may not be able to use DBMS_SCHEDULER ? And i can use DBMS_JOB ..
Re: DBMS job [message #380927 is a reply to message #380926] Wed, 14 January 2009 02:51 Go to previous messageGo to next message
v.ram81
Messages: 50
Registered: April 2006
Location: pune
Member

Yes..
Use DBMS_JOB ..

Regards,
Ram
Re: DBMS job [message #380930 is a reply to message #380917] Wed, 14 January 2009 03:00 Go to previous message
shaksing
Messages: 115
Registered: November 2008
Senior Member
Okk Thanks
Previous Topic: Had a Problem with type in function
Next Topic: How to insert multiple records in single statement
Goto Forum:
  


Current Time: Sat Feb 08 14:00:29 CST 2025