翻译文献Using the Scheduler to Automate Tasks.docVIP

大连交通大学2016届本科生毕业设计（论文）外文翻译 外文原文 Using the Scheduler to Automate Tasks As an Oracle database administrator, you might find that an inordinateamount of your time is spent performing routine tasks.Unfortunately, routine tasks come with the territory, and that isunlikely to change in the foreseeable future. Handling these routine tasks manually is an invitationfor problems. Mistakes can be made, or even worse, the tasks will be forgotten and not run at all.To resolve this dilemma, Oracle Database 10g(Oracle 10g) introduced the Oracle Scheduler,a new feature that makes the scheduling of routine tasks a simple matter. The Oracle Scheduleris a major advancement over the oldDBMS_JOBscheduling system found in previouOracle versions.It corrects many of the nagging idiosyncrasies while adding powerful new featuressuchas the calendaring syntax, a flexible method of defining repeat intervals for Scheduler jobs.In this chapter, you will learn how the Scheduler works and how to create and manageScheduler elements. First, you will get an overview of the terminology and components thatmake up the Scheduler. You will learn the underlying architecture of the Scheduler and how allthe pieces fit together. Next, you will learn about Scheduler jobs and how to create and manage them. You will also learn about job groups and how they can be used to simplify the management of jobs, as well as to prioritize job execution.You will also learn about Scheduler programs, which define the work that will be performed.You’ll learn to create and manage schedules, which define when jobs will be run and how oftenthey will be repeated. You’ll learn how to define complex repeat intervals using Oracle’snewalendaring syntax.Next, you will learn about windows and window groups, which allow you to switch resourceplans based on a schedule. And, lastly, you will learn about the Scheduler views that are availableto you. Scheduler Overview The main functionality of any enterprise scheduling system is the ability