Solved

Difference between Jobs and Scheduler Jobs

Posted on 2011-03-18
2
554 Views
Last Modified: 2012-05-11

We are trying to build the Team Foundation Server to maintain the versions of the scripts and in that process, we are generating scripts for the Database objects.

When I generate the scripts for "JOBS" and "SCHEDULED JOBS" from TOAD, I see different scripts.

Do we need both of these.  What is the difference between these "JOBS" and "SCHEDULED JOBS". Do I have to generate them separately or generating one should be good.

Please advise asap

Thanks

0
Comment
Question by:d27m11y
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 250 total points
ID: 35170352
JOBS are created by DBMS_JOBS package

SCHEDULED JOBS are created by DBMS_SCHEDULER

DBMS_SCHEDULER has a much more sophisticated set of functionality than DBMS_JOBS and can do anything that DBMS_JOBS can do and is intended to replace DBMS_JOBS.

However, there is one important limitation.  DBMS_SCHEDULER autocommits all actions with each call.  DBMS_JOBS does not.

If that distinction isn't important to you than you should use DBMS_SCHEDULER since it is the direction of Oracle's future scheduling plans.


0
 
LVL 5

Expert Comment

by:anand_20703
ID: 35196853
I understood from the above description : : At the moment, ddls from both dbms_jobs and scheduler_jobs can taken & saved.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question