Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering Oracle Scheduler in Oracle 11g Databases
  • Table Of Contents Toc
  • Feedback & Rating feedback
Mastering Oracle Scheduler in Oracle 11g Databases

Mastering Oracle Scheduler in Oracle 11g Databases

By : Ronald Rood
5 (3)
close
close
Mastering Oracle Scheduler in Oracle 11g Databases

Mastering Oracle Scheduler in Oracle 11g Databases

5 (3)
By: Ronald Rood

Overview of this book

Scheduler (DBMS_SCHEDULER) is included in Oracle Database and is a tool for the automation, management, and control of jobs. It enables users to schedule jobs running inside the database such as PL/SQL procedures or PL/SQL blocks, as well as jobs running outside the database like shell scripts. Scheduler ensures that jobs are run on time, automates business processes, and optimizes the use of available resources. You just need to specify a fixed date and time and Scheduler will do the rest. What if you don't know the precise time to execute your job? Nothing to worry about, you can specify an event upon which you want your job to be done and Scheduler will execute your job at the appropriate time. Although scheduling sounds quite easy, it requires programming skills and knowledge to set up such a powerful, intelligent scheduler for your project. This book is your practical guide to DBMS_SCHEDULER for setting up platform-independent schedules that automate the execution of time-based or event-based job processes. It will show you how to automate business processes, and help you manage and monitor those jobs efficiently and effectively. It explains how Scheduler can be used to achieve the tasks you need to make happen in the real world. With a little understanding of how the Scheduler can be used and what kind of control it gives, you will be able to recognize the real power that many known enterprise-class schedulers ñ with serious price tags ñ cannot compete with. You will see how running a specific program can be made dependent on the successful running of certain other programs, and how to separate various tasks using the built-in security mechanisms. You will learn to manage resources to balance the load on your system, and gain increased database performance.
Table of Contents (15 chapters)
close
close
Mastering Oracle Scheduler in Oracle 11g Databases
Credits
About the Author
About the Reviewers
chevron up
Preface

About the Reviewers

Hans Forbrich has been around computers for 40 years. While studying for his B.Sc. EE in the 70s, he worked as a contract programmer to help pay for school. Hans has been working with the Oracle products since 1984. While at Nortel in the field service group, he met Oracle Database version 4. He joined Oracle Canada to work in the Communications vertical from 1996 to 2002. In 2003, Hans started Forbrich Computer Consulting Ltd., which has become a successful international Oracle consultancy and Oracle training partner based in St. Albert, near Edmonton, Alberta, Canada.

As an Oracle ACE Director and OCP, Hans frequently responds in various Oracle Forums, teaches for Oracle University, consults with Oracle customers on maximizing value from Oracle licenses, and speaks at Oracle User Group conferences around the world. He holds a strong belief that Oracle products provide significant value, and the key to extracting that value—and reducing the effective cost of the product—is in understanding the product and using the right tool for the job.

Mennan Tekbir has a master's degree in Computer Sciences, and has worked for several telecommunications companies around the world. He is mainly focused on performance analysis, designing and implementing frameworks, automated PL/SQL code generation, and fraud detection with data mining.

Robin Buitenhuis is an experienced Oracle DBA. During his study at the Universiteit Twente, he came in contact with Oracle RDBMS 6.0 en Forms 2.3. From that moment on, he has always worked with Oracle products. He is also a member of the board of the Dutch Oracle Usergroup (www.ogh.nl).

Syed Jaffar Hussain has more than 16 years of Information Technology (IT) experience, which includes over eight years as a Production Oracle DBA. He is an Oracle ACE, Oracle 10g Certified Master (OCM), OCP DBA (v8i, 9i, and10g), and Oracle 10g RAC Certified Expert. He is currently involved in 8 node production and 6 node development RAC setup with more than 60 databases running across the nodes. He has a broad experience in Oracle advanced technologies such as RAC, DataGuard, RMAN, and Performance Tuning. He occasionally presents Oracle University five-day courses and one-day seminars on behalf of Oracle EMEA. He has also worked for a couple of multinational banks in Saudi Arabia. He is currently involved with the Oracle 11g RAC book.

He is a frequent contributor at Oracle OTN forums and regularly writes to his blog, (http://jaffardba.blogspot.com). He is reachable at

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering Oracle Scheduler in Oracle 11g Databases
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon