[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

posted @ 2013-05-28 15:09  ArcerZhang  阅读(146)  评论(0编辑  收藏  举报