Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Jobs and Job Classes


The Job is the programmed execution of a task at a given time and during a given period of time. Once the schedule and the program objects have been defined, they can be used in a job definition making it simpler and more readable.

BEGIN
sys.dbms_scheduler.create_job(
job_name => '"OSCHEDULER"."OS_LOG_RECORDS_JOB"',
program_name => 'OSCHEDULER.OS_LOG_RECORD_PROG',
schedule_name => 'OSCHEDULER.MINUTELY_SCHEDULE',
job_class => 'DEFAULT_JOB_CLASS',
auto_drop => FALSE,
enabled => TRUE);
END;

A Job Class is a way of grouping jobs and linking them to a resource consumer group, so that you can define common properties among different jobs in a single operation. This enables the same behavior and same properties among homogeneous jobs. You can specify attributes at the class level; you can also define the order in which a job is started. Linking to resource manager is important as this is a way you can emphasize the resources allocated to all the jobs that...