How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Scheduler Architecture → temporarily 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.
Scheduler Reference → This section contains reference information for Oracle Scheduler. It contains the following topics: Scheduler Privileges Scheduler Data Dictionary Views
Scheduler Privileges → Table 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
30 Administering Oracle Scheduler → In 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
Scheduler Data Dictionary Views → You 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
Overview of Oracle Scheduler → Oracle 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
Configuring Oracle Scheduler → Configuring Oracle Sched uler This section contains: Setting Oracle Scheduler Privileges Setting … Scheduler Preferences Using the Oracle Scheduler Agent to Run Remote Jobs
Managing Scheduler Security → need 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
Oracle Scheduler and Editions → Scheduler jobs always use the database default edition. See Also: Oracle Database Advanced
Setting Scheduler Preferences → There 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
Troubleshooting the Scheduler → This section contains the following troubleshooting topics: A Job Does Not Run A Program Becomes Disabled A Window Fails to Take Effect
28 Oracle Scheduler Concepts → In 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
Setting Oracle Scheduler Privileges → You 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
Monitoring and Managing the Scheduler → Monitoring 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
Examples of Using the Scheduler → Examples 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
Import/Export and the Scheduler → Scheduler 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
About Scheduler Objects and Their Naming → About 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
Using Both DBMS_JOB and Oracle Scheduler → DBMS_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
About Jobs and Supporting Scheduler Objects → To 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
29 Scheduling Jobs with Oracle Scheduler → In 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.