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: 117
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??
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: 57609
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean by "oracle jobs"?

Regards
Michel
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
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
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: 194
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.
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: 57609
Registered: March 2007
Location: Nanterre, France, http://...
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

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: 194
Registered: May 2012
Location: Orlando, FL
Senior Member

Learn something new every day. I've never used DBMS_JOB since DBMS_SCHEDULER came out.
Previous Topic: Books for Oracle JDeveloper
Next Topic: Training for Oracle Forms and Reports.
Goto Forum:
  


Current Time: Fri Apr 18 11:46:59 CDT 2014

Total time taken to generate the page: 0.04891 seconds