You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for scheduler


1 to 20 of 473 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Administrator's Guide, 11g Release 2 (11.2)

Oracle Scheduler Concepts

Scheduler Architecturetemporarily leave it unassigned to any job. Scheduler Arch itecture This section discusses the … Scheduler architecture, and describes: The Job Table The Job Coordinator How Jobs Execute After Jobs … Complete Using the Scheduler in Real Application Clusters Environments Figure 28-6 illustrates how jobs are handled by the database.

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Scheduler ReferenceThis section contains reference information for Oracle Scheduler. It contains the following topics: Scheduler Privileges Scheduler Data Dictionary Views

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Scheduler PrivilegesTable 30-3, \"Scheduler System Privileges\" and Table 30-4, \"Scheduler Object Privileges … \" describe the various Scheduler privileges. Table 30-3 Scheduler System Privileges Privilege Name Operations … jobs to run under any job class. MANAGE SCHEDULER This is the most important privilege for

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

30 Administering Oracle SchedulerIn this chapter: Configuring Oracle Scheduler Monitoring and Managing the Scheduler Import/Export … and the Scheduler Troubleshooting the Scheduler Examples of Using the Scheduler Scheduler Reference … Note: This chapter describes how to use the DBMS_SCHEDULER package to administer Oracle

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Scheduler Data Dictionary ViewsYou can check Scheduler information by using many views. An example is the following, which shows … # -------- -------------- ------ MY_JOB1 FAILURE 20000 Table 30-5 contains views associated with the Scheduler. The *_SCHEDULER_JOBS … details regarding Scheduler views. Note: In the following table, the asterisk at the beginning of a

Database Administrator's Guide, 11g Release 2 (11.2)

Oracle Scheduler Concepts

Overview of Oracle SchedulerOracle Database includes Oracle Scheduler, an enterprise job scheduler to help you simplify the … scheduling of hundreds or even thousands of tasks. Oracle Scheduler (the Scheduler) is implemented by … the procedures and functions in the DBMS_SCHEDULER PL/SQL package. The Scheduler enables you to

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Configuring Oracle SchedulerConfiguring Oracle Sched uler This section contains: Setting Oracle Scheduler Privileges Setting … Scheduler Preferences Using the Oracle Scheduler Agent to Run Remote Jobs

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Managing Scheduler Securityneed to be able to use the Scheduler to schedule and run jobs. You should grant MANAGE SCHEDULER to … any database administrator who must be able to manage system resources. Granting any other Scheduler … EXTERNAL JOB system privilege to those users. Security for the Scheduler has no other special

Database Administrator's Guide, 11g Release 2 (11.2)

Oracle Scheduler Concepts

Oracle Scheduler and EditionsScheduler jobs always use the database default edition. See Also: Oracle Database Advanced

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Setting Scheduler PreferencesThere are several systemwide Scheduler preferences that you can set. You set these preferences by … setting Scheduler attributes with the SET_SCHEDULER_ATTRIBUTE procedure. Setting these attributes … requires the MANAGE SCHEDULER privilege. The attributes are: default_timezone It is very important that … which time zone to use

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Troubleshooting the SchedulerThis section contains the following troubleshooting topics: A Job Does Not Run A Program Becomes Disabled A Window Fails to Take Effect

Database Administrator's Guide, 11g Release 2 (11.2)

Oracle Scheduler Concepts

28 Oracle Scheduler ConceptsIn this chapter: Overview of Oracle Scheduler About Jobs and Supporting Scheduler Objects More … About Jobs Scheduler Architecture Scheduler Support for Oracle Data Guard Oracle Scheduler and Editions

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Setting Oracle Scheduler PrivilegesYou must have the SCHEDULER_ADMIN role to perform all Oracle Scheduler administration tasks … granting individual Scheduler system privileges instead. Object and system privileges are granted … administrator issues the following statement: GRANT MANAGE SCHEDULER TO adam; After this statement is … set and retrieve Scheduler

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Monitoring and Managing the SchedulerMonitoring and Mana ging the Scheduler The following sections discuss how to monitor and manage the … Scheduler: Viewing the Currently Active Window and Resource Plan Finding Information About … Currently Running Jobs Monitoring and Managing Window and Job Logs Managing Scheduler Security

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Examples of Using the SchedulerExamples of Using the Schedu ler This section discusses the following topics: Examples of Creating Job Classes Examples of Setting Attributes Examples of Creating Chains Examples of Creating Jobs and Schedules Based on Events Example of Creating a Job In an Oracle Data Guard Environment

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Import/Export and the SchedulerScheduler objects. You cannot use the earlier import/export utilities ( IMP and EXP ) with the … Scheduler. Also, Scheduler objects cannot be exported while the database is in read-only mode. An export … generates the DDL that was used to create the Scheduler objects. All attributes are exported. When … database

Database Administrator's Guide, 11g Release 2 (11.2)

Scheduling Jobs with Oracle Scheduler

About Scheduler Objects and Their NamingAbout Scheduler Obje cts and Their Naming You operate Oracle Scheduler by creating and managing a … set of Scheduler objects. Each Scheduler object is a complete database schema object of the form … [schema.]name. Scheduler objects follow the naming rules for database objects exactly and share the SQL

Database Administrator's Guide, 11g Release 2 (11.2)

Support for DBMS_JOB in Oracle Database 11g Release 2

Using Both DBMS_JOB and Oracle SchedulerDBMS_JOB and Oracle Scheduler (the Scheduler) use the same job coordinator to start job slaves. You … DBMS_JOB and the Scheduler. If JOB_QUEUE_PROCESSES is 0, both DBMS_JOB and Oracle Scheduler jobs are … disabled. See Also: Chapter 29, \"Scheduling Jobs with Oracle Scheduler\" \"Setting Scheduler

Database Administrator's Guide, 11g Release 2 (11.2)

Oracle Scheduler Concepts

About Jobs and Supporting Scheduler ObjectsTo use the Scheduler, you create Scheduler objects. Schema objects define the what, when, and where … for job scheduling. Scheduler objects enable a modular approach to managing tasks. One advantage of … existing tasks. The principal Scheduler object is the job. A job defines the action to perform, the … scheduler

Database Administrator's Guide, 11g Release 2 (11.2)

Scheduling Jobs with Oracle Scheduler

29 Scheduling Jobs with Oracle SchedulerIn this chapter: About Scheduler Objects and Their Naming Creating, Running, and Managing Jobs … chapter describes how to use the DBMS_SCHEDULER package to work with Scheduler objects. You can accomplish … Reference for DBMS_SCHEDULER information and the Oracle Enterprise Manager online help for information on Oracle Scheduler pages.