Oracle Security

OEM and the Job Scheduler

The OEM provides you with the ability to configure a set of jobs to be automatically run on one or more of your databases. You can set up the jobs to run at the same time on each database or at different times. Oracle supplies a list of commonly used jobs to choose from. You can also write your own customized scripts and schedule them to run automatically.

As with all the OEM utilities, the OEM Job Scheduler uses the intelligent agent on each computer node to perform the actual work that has been scheduled. There is only one intelligent agent per node, regardless of how many databases are on that node or how many jobs have been scheduled to be run against those databases.

The default tasks provided with the OEM Job Scheduler utility can be run either one time or on a scheduled basis:

• Back up tablespace

• Export

• Import

• Load

• Run DBA script

• Run SQL*Plus

• Shut down database

• Start up database

• Broadcast message

• Run OS command

• Run TCL

• Deinstall product

• Delete package

• Distribute package

• Install package

Many of these tasks help protect your databases, as we describe in the following sections.

Back Up Tablespaces, Export, Import, and Load Data

The ability to back up tablespaces on a scheduled basis is a wonderful option that helps ensure you can recover your database to either the last time the tablespaces were backed up or to a point in time after the last backup (if archivelog mode has been enabled). However, if you are going to schedule automatic tablespace backups, ...