Home » Other » Training & Certification » oracle jobs basic tutorials (Oracle 10g, Win7)
oracle jobs basic tutorials [message #562198] Mon, 30 July 2012 06:18 Go to next message
nischalinn
Messages: 118
Registered: May 2012
Location: nepal
Senior Member
I want to learn about oracle jobs. Its a new topic for me. I've done googling but
did not found simple tutorials for this topic,all the tutorials were very
complex.

Can anyone provide me some simple tutorials on this topic??

Report message to a moderator

Re: oracle jobs basic tutorials [message #562199 is a reply to message #562198] Mon, 30 July 2012 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What do you mean by "oracle jobs"?

Regards
Michel

Report message to a moderator

Re: oracle jobs basic tutorials [message #562200 is a reply to message #562198] Mon, 30 July 2012 06:20 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member
 

http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_job.htm

Report message to a moderator

Re: oracle jobs basic tutorials [message #562201 is a reply to message #562200] Mon, 30 July 2012 06:22 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member
Very useful.....
http://sqle.ru/index.php/Oracle_PL/SQL_Tutorial/System_Packages/DBMS_JOB

Report message to a moderator

Re: oracle jobs basic tutorials [message #562239 is a reply to message #562201] Mon, 30 July 2012 12:16 Go to previous messageGo to next message
matthewmorris68
Messages: 258
Registered: May 2012
Location: Orlando, FL
Senior Member
What version of Oracle are you using? DBMS_JOB was effectively replaced by DBMS_SCHEDULER in release 10G. It's still around for backward compatibility, but not something I'd use unless you have 9i or older.

Report message to a moderator

Re: oracle jobs basic tutorials [message #562251 is a reply to message #562239] Mon, 30 July 2012 13:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
DBMS_JOB was effectively replaced by DBMS_SCHEDULER in release 10G.


Not at all, DBMS_SCHEDULER does NOT supersede of DBMS_JOB, they have different scopes.
For instance, DBMS_SCHEDULER is auto-committed when DBMS_JOB is part of your transaction and job submission is committed or rolled back with your transaction, something you can't do with DBMS_SCHEDULER.
So it is not still there for backward compatibility, it is still there because it fulfils something DBMS_SCHEDULER can't achieve.

Regards
Michel

Report message to a moderator

Re: oracle jobs basic tutorials [message #562257 is a reply to message #562251] Mon, 30 July 2012 14:17 Go to previous message
matthewmorris68
Messages: 258
Registered: May 2012
Location: Orlando, FL
Senior Member
Learn something new every day. I've never used DBMS_JOB since DBMS_SCHEDULER came out.

Report message to a moderator

Previous Topic: Books for Oracle JDeveloper
Next Topic: Training for Oracle Forms and Reports.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 07 00:27:13 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.