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 Reference → This section contains reference information for Oracle Scheduler. It contains the following topics: Scheduler Privileges Scheduler Data Dictionary Views
Scheduler Privileges → Table 28-2 lists the various Scheduler privileges. Table 28-2 Scheduler Privileges Privilege Name … job class. MANAGE SCHEDULER This is the most important privilege for administering the Scheduler. It … to set and retrieve Scheduler attributes, purge Scheduler logs, drop public credentials,
Scheduler Architecture → Scheduler Arch itecture This section discusses the Scheduler's architecture, and describes: The Job … Table The Job Coordinator How Jobs Execute Job Slaves Using the Scheduler in Real Application … Clusters Environments Figure 26-4 illustrates how jobs are handled by the database. Figure 26-4 Scheduler … Components Description
Scheduler Objects → Sche duler Objects To use the Scheduler, you create Scheduler objects. These are schema objects … that define the what, when, and how for job scheduling. Scheduler objects enable a modular approach to … new tasks that are similar to existing tasks. All Scheduler objects have attributes. You assign values … to
Configuring Oracle Scheduler → Configuring Oracle Sched uler The following tasks are necessary when configuring Oracle Scheduler … (the Scheduler): Task 1: Setting Scheduler Privileges Task 2: Configuring the Scheduler Environment … Task 1: Setting Scheduler Privileges You should have the SCHEDULER_ADMIN role to administer the
Stopping the Scheduler Agent → Stopping the Scheduler agent prevents the host on which it resides from running remote external … jobs. To stop the Scheduler agent: Do one of the following: On UNIX and Linux, run the following
Managing Scheduler Security → need to be able to use the Scheduler to schedule and run jobs. You should grant MANAGE SCHEDULER to … Scheduler system privilege or role should not be done without great caution. In particular, the CREATE … . Security for the Scheduler has no other special requirements. See Oracle Database Security Guide
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 28-3 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
28 Administering Oracle Scheduler → In this chapter: Configuring Oracle Scheduler Monitoring and Managing the Scheduler Enabling and … Disabling Remote External Jobs Import/Export and the Scheduler Troubleshooting the Scheduler Examples … of Using the Scheduler Scheduler Reference Note: This chapter describes how to use
Overview of Oracle Scheduler → includes Oracle Scheduler, an enterprise job scheduler. Oracle Scheduler (the Scheduler) is implemented by … the procedures and functions in the DBMS_SCHEDULER PL/SQL package. The Scheduler enables you to … control when and where various computing tasks take place in the enterprise environment.The Scheduler
Troubleshooting the Scheduler → This section contains the following troubleshooting topics: Understanding Why a Job Fails to Run Job Recovery After a Failure Understanding Why a Program Becomes Disabled Understanding Why a Window Fails to Take Effect
26 Oracle Scheduler Concepts → In this chapter: Overview of Oracle Scheduler Programs Schedules Jobs Chains Job Classes Windows … Window Groups Scheduler Architecture Scheduler Support for Oracle Data Guard
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
Using the Scheduler Calendaring Syntax → attribute with a Scheduler calendaring expression. See Oracle Database PL/SQL Packages and Types Reference
Scheduler Objects and Their Naming → Scheduler Obje cts and Their Naming Each Scheduler object is a complete database schema object of … the form [schema.]name. Scheduler objects exactly follow the naming rules for database objects and … share the SQL namespace with other database objects. When names for Scheduler objects are used in the … DBMS_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 Changing Job Priorities Managing Scheduler Security
What Can the Scheduler Do? → The Scheduler provides sophisticated, flexible enterprise scheduling functionality, which you can … . Remote systems do not require an Oracle Database installation; they require only a Scheduler agent … . Scheduler agents are available for all platforms supported by Oracle Database and some additional … \"the last Wednesday of
Examples of Using the Scheduler → Examples of Using the Schedu ler This section discusses the following topics: Examples of Creating Jobs Examples of Creating Job Classes Examples of Creating Programs Examples of Creating Windows 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
Service Affinity when Using the Scheduler → The Scheduler enables you to specify the database service under which a job should be run (service … example of how services and instances could be used. Figure 26-6 Service Affinity and the Scheduler … Description of \"Figure 26-6 Service Affinity and the Scheduler\" In Figure 26-6, you could change the … properties of the services
The Job Coordinator → coordinator continues to run. After there has been a certain period of Scheduler inactivity and there are no … job coordinators for those two instances are started. See \"Service Affinity when Using the Scheduler … per instance. This is also the case in RAC environments. See Also: \"Scheduler Data Dictionary Views … \" for job