Automating Routine Tasks

Abstract

Oracle provides methods to schedule one-time and recurring jobs within the database, which is beneficial when you want to automate repetitive tasks and run them at times when a DBA may not be available. This chapter provides recipes to help you get started scheduling jobs (especially PL/SQL jobs), capturing output, sending e-mail notifications, and keeping data in sync with other databases.