Automating Tasks Using Oracle Scheduler

Introduction

The Automating Tasks Using Oracle Scheduler module will talk about the Oracle Scheduler job management system.

• Understanding Oracle Scheduler
• Using Oracle Scheduler
• Relating Tasks with Job Chains
• Scheduling Jobs on Remote Systems
• Prioritizing Jobs with Oracle Scheduler

Exercise 1 - Understanding Oracle Scheduler

In this exercise you will learn the following about Oracle Scheduler:

• Establishing a connection to the database
• Granting Scheduler Privileges
• Understanding Job States

The Oracle Scheduler is the utility that allows the jobs that are scheduled to be executed inside Oracle Database 12c regardless of the platform on which the database is running. All the procedures that are required to implement the automated scheduling and execution of jobs inside the database are included in the DBMS_SCHEDULER package.

Exercise 2 - Using Oracle Scheduler

In this exercise, you will learn the following about Oracle Scheduler:

• Working with Schedules
• Working with Jobs
• Job Classes
• Groups
• Creating a Program
• Creating a Window

Exercise 3 - Relating Tasks with Job Chains

In this exercise, you will learn the following about tasks relating with job chains:

• Using Job Chains to Perform a Series of Related Tasks

Exercise 4 - Scheduling Jobs on Remote Systems

In this exercise, you will learn the following about Scheduling Jobs on Remote System:

• Scheduling Jobs on Remote Systems

Exercise 5 - Prioritizing Jobs With Oracle Scheduler

In this exercise, you will learn the following:

• Prioritizing Jobs With Oracle Scheduler