Window Groups in Font

Generation Code39 in Font Window Groups

A window group is a collection of similar windows. For example, you can create a window for your weekends and a window for your holidays, and group both these windows into a single maintenance window group.

The Scheduler architecture consists of the job table, job coordinator, and the job workers (or slaves, as Oracle calls them). The job table contains information about jobs, such as the job name, program name, and job owner. You can examine the job table by using the DBA_SCHEDULER_JOBS view. The job coordinator regularly looks in the job table to find out what jobs to execute. The job coordinator creates and manages the job worker processes, which actually execute the job. When you create a new job or execute a job, a background process (cjqnnn) wakes up and coordinates the running of the job. When the job coordinator tells a job worker to execute a job, the worker process starts a new database session and starts a transaction. It executes the job, and once completed, it commits and ends the transaction and terminates the database session. The job worker updates the job table, the run count, and the job log table.

Oracle creates all jobs, programs, and schedules in the schema of the user that creates these objects, but it creates all the advanced Scheduler components, like job classes, windows, and window groups, at the database level, and their owner is the SYS schema. The SCHEDULER_ADMIN role contains all Scheduler system privileges, with the WITH ADMIN OPTION clause. The DBA role contains the SCHEDULER_ADMIN role. The MANAGE SCHEDULER system privilege lets you do the following: Create, drop, and alter job classes, windows, and window groups. Stop any job. Start and stop windows prematurely.

All Scheduler objects are of the form [schema.]name. By default, all scheduler object names are in uppercase, unless you wrap the lowercase names in double quotes, as in "test_job".

You must have the CREATE JOB privilege to create Scheduler components (jobs, schedules, programs, chains, and events). To use the advanced Scheduler components (windows, window groups, and job classes), you need the MANAGE SCHEDULER system privilege. You can assign other users the right to use one of your components by giving them EXECUTE privileges on that component: The EXECUTE ANY PROGRAM privilege lets a user execute any program under any schema. The EXECUTE ANY CLASS privilege lets you assign a job to any job class.

In order for users to modify Scheduler components, they must use the GRANT ALTER SQL statement for each Scheduler component.

To be able to create a job in a job class you generate, you must have a separate EXECUTE privilege on that

Note the following basic points regarding Scheduler privileges: To create a job, you must have the CREATE JOB privilege. You don t need any special privileges to specify a schedule, a window or window group, or a program that you own. If you specify a program owned by a different user, you must have the EXECUTE privilege on that program, or the EXECUTE ANY PROGRAM system privilege.

The basic Scheduler components jobs, programs, schedules, chains, and events have several common manageability features. You create, alter, and drop all the components with the same procedure from the DBMS_SCHEDULER package. The following sections describe how to manage these components.

Creating and managing jobs is at the heart of the Scheduler feature. You can create and run jobs independently, or you can create a job using schedules and programs. Using saved programs and schedules saves you having to redefine a program or schedule each time you create a new job.