Scheduler uses - Complex enterprise scheduling functionality - Oracle DBA

Discussion

• Nirja Shah   -Posted on 26 Aug 15
  The Scheduler provides complex enterprise scheduling functionality, which can be used for the following:
  
  -Schedule job execution based on time or events - The most basic capability of a job scheduler is the ability to schedule a job to run at a particular date and time or when a particular event occurs.
  -The Scheduler enables you to reduce your operating costs by enabling you to schedule execution of jobs.
  
  -Schedule job processing in a way that models your business requirements - The Scheduler enables limited computing resources to be allocated appropriately among competing jobs, thus aligning job processing with your business needs.
  
  -Manage and monitor jobs - There are multiple states that a job undergoes from its creation to its completion.
  -Scheduler activity is logged and information such as the status of the job and the last run time of the job can be easily tracked.
  -This information is stored in views and can be easily queried using Enterprise Manager or a SQL query.
  -These views provide valuable information about jobs and their execution that can help you schedule and manage your jobs better.
  
  -Execute and manage jobs in a clustered environment - A cluster is a set of database instances that cooperates to perform the same task.
  -The Scheduler fully supports execution of jobs in such a clustered environment.
  -To balance the load on your system and for better performance, you can also specify the database service where you want a job to run.

➨ Post your comment / Share knowledge