[bbk5154]第53集第6章 用scheduler自动化 01

Simplifying Management Tasks

• Performing a series of month-end tasks on the last day of each month
• Running a dequeue procedure as soon as a message is enqueued
• Replicating table data via materialized view refreshes
• Running a daily job to back up database
• Computing table and index statistics twice a day
• Startting the batch load as soon as the file arrives on the file system
• Generating an hourly report on invalid server access attempts
• Rebuilding an index when finished rebuilding the current index

program、job、schedule三者之间的关系

• 干什么---program
• 什么时间干什么事---job
• 什么时间，间隔多久做---schedule
• job通过schedule来调用program 

Core Components