?
Solved

Difference between Jobs and Scheduler Jobs

Posted on 2011-03-18
2
Medium Priority
?
612 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 1000 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

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.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

770 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