Oracle 10g Scheduler Overview

Automation is key process to reduce IT operating expense. An effective scheduler should have features that can automate business process with manual intervention and be easily mange/monitor the scheduled jobs. Scheduler was introduced in Oracle 10g and has exciting features. Few are listed below.

• Build into database. No extra license fee.
  
• DBA has Control over when and what to execute.
• Platform independent (Management is similar across platform).
• Can be exported using IMP/EXP utility.
• Can execute Shell scripts, PL/SQL block, PL/SQL or Java stored procedures.
• It can be accessed/controlled from enterprise manager (EM) or through DBMS_SCHEDULER API.
• Can schedule the job based on time and also on event.
  

For more information please visit
http://www.oracle.com/technology/products/database/scheduler/index.html