Solved

Difference between Jobs and Scheduler Jobs

Posted on 2011-03-18
2
531 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
2 Comments
 
LVL 73

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now