Run the "b" script, located in the "$ORACLE_HOME/rdbms/admin" directory.ĬONN / AS set a password for the scheduler agent registration using the DBMS_SCHEDULER package.ĮXEC DBMS_t_agent_registration_pass('agent_passwd') Oracle Scheduler Agent Installation If it is not set, set it using the SETHTTPPORT procedure. If XML DB is already installed, check the HTTP port has been set using the GETHTTPPORT function in the DBMS_XDB package. If the following command returns an "object does not exist" error, XML DB is not installed on the database and must be installed before you proceed. First we must check XML DB is installed and has the HTTP port set. Make sure the scheduler's default timezone is set correctly.īefore we can create a remote external job we need to do some configuration on the database server. This agent is responsible for executing the jobs and communicating with the database server that initiated the job.įor a user to create local or remote external jobs, they must be granted the CREATE JOB and CREATE EXTERNAL JOB privileges. The remote server doesn't have to have an Oracle client or database installation, but it must have an Oracle Scheduler Agent installation. Oracle 11g takes this one step further by allowing the database to schedule external jobs which run on a remote server. Oracle 10g introduced the concept of external jobs. Disabling Remote External Job Functionality.Now Oracle 11g adds more functionality to the Oracle scheduler. Oracle 10g Release 1 introduced the new Oracle scheduler and Oracle 10g Release 2 enhanced it. Home » Articles » 11g » Here Scheduler Enhancements in Oracle Database 11g Release 1
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |