Automating Routine Tasks
Josh Juneau, Matt Arena · Apress eBooks · 2010
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.