Mastering Oracle Scheduler in Oracle 11g Database
by Ronald Rood

A practical guide for Database Administrators and Developers to setting up enterprise class job scheduling

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.

Read Mastering Oracle Scheduler in Oracle 11g Database Book Review

This book is available for purchase at packtpub.com

---

---

Mastering Oracle Scheduler in Oracle 11g Database  by  Ronald Rood A practical guide for Database Administrators and Developers to setting up enterprise class job scheduling 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...
So far we have mostly used jobs that ran immediately upon being enabled or when we called the run_job procedure of the dbms_scheduler package. Many jobs are time-based; they are controlled by a schedule based on some kind of calendar. However not everything in real life can be controlled by a calendar. Many things need an action on an ad hoc basis...
In other third-party scheduling packages I have seen these notification actions implemented as part of the chain definitions because they lack a Scheduler event queue. In such packages messages are sent by mail in extra chain steps. In the Oracle Scheduler this queue is present and is very useful for us. Compared to 10g nothing has changed in...
On many occasions a calendar will do fine for scheduling jobs. However there are situations that require an immediate action and which cannot wait for the next activation based on a calendar. An example might be of a user who logs on to the database and then using a logon trigger more actions are executed. Another example could be a situation...
The following objects show up in the schema which are created to support the queue table This also explains why MARVIN needs quota on his default tablespace. The queue definitions part is ready. Now we can tie a job to the queue. First create a job as follows geshibot language sql -- BEGIN sys.dbms_scheduler.create_job job_name...
The result is that all of the jobs waiting for the GO message are started at the same time. With the health of the backup system in mind it would be wiser to query the jobs view find the backup job that was scheduled first and give that job its specific event. In that case the BCKUP_01 job will wait for the message BCKUP_01; and BCKUP_02 will wait...