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

Getting started with the Oracle Scheduler


There are a number of database privileges and properties that need to be set for a user to be able to access and utilize the Scheduler. Once the user has been granted the proper privileges they are ready to use the DBMS_SCHEDULER package.

Required privileges

In order for you to create a new job manager you must grant the SCHEDULER_ADMIN role.

GRANT SCHEDULER_ADMIN TO <username>;

This role provides a lot of power for a regular user, allowing the grantee to run any code. If this happens to be a regular user who will launch its own jobs, then it should be granted the CREATE JOB privilege. This allows the grantee to create jobs, schedules, and programs in its own schema.

GRANT CREATE JOB TO <username>;

If the user will be performing other management tasks besides creating jobs and schedules, then the DBA should grant the MANAGE SCHEDULER privilege. This allows the grantee to create, alter or drop windows, job classes, and windows groups,...