Schedule, manage, and carry out work that automate your business processes. Automate tasks from within an Oracle database with built-in Scheduler. Contains easy to understand explanations, simple examples, debugging tips, and real-life scenarios. In Detail Scheduler (DBMS_SCHEDULER) is included in Oracle Database and is a tool for automation, management, and control work. It allows users to schedule jobs that run in the database as PL / SQL or procedure / PL SQL block, as well as jobs that run outside the database, such as shell scripts. Scheduler ensures that the work carried out on time, automatic business processes, and optimize use of available resources. You only need to specify the date and time is fixed and the scheduler will do the rest. Not to worry, you can specify the above events where you want your work to be done and the Scheduler will run your work at the right time. Although scheduling sound simple enough, it requires programming skills and knowledge to prepare such a strong, intelligent scheduler for your project. This book is your practical guide to DBMS_SCHEDULER to prepare a schedule-independent platform that automates the process of carrying out the work based on time or event-based. 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 strength that many enterprise-class scheduler is known - with a serious price tag - can not compete with. You will see how to run a specific program can be made dependent on the successful running of certain other programs, and how to separate the various tasks using the built-in security mechanisms. Combine your resources manager and scheduler to obtain the maximum throughput to manage thousands of jobs at a time. Run the job on a machine that does not have a database running on a remote job agent.