Mastering Oracle Scheduler in Oracle 11g Databases

Chapter 9. Other Configurations

I hope that the previous chapters gave enough handles to start working with the Scheduler. I am aware that there is a lot more to tell about the Scheduler, and this chapter will shed light on some other configurations where the Scheduler can be used. This time it is about RAC (Real Application Clusters) and the standby databases.

RAC

When the jobs you are running depend on things other than just the database, it might be interesting to know what these other things are, and where they can be found. There are several ways to control which instance a job is going to run, some of which are:

• Define instance_id in the job definition

• Use instance_stickiness in the job definition

• Define service_name in the job class definition ...