Enabling and Disabling Remote External Jobs

1. Setting Up the Database

Before a database can execute jobs using a remote Scheduler agent, the agent must be registered with the database. To make the registration of remote Scheduler agents secure, an agent registration password must be set on the database. You can limit the number of Scheduler agents that can register, and you can set the password to expire after a specified duration.

• To verify that the XML DB option is installed

SQL>Desc RESOURCE_VIEW
-- return "öbject does not exist", XML DB is not installed, must install it before continuing

• Enable HTTP connections to the database
  

BEGIN
    DBMS_XDB.SETHTTPPORT(port);
END;
port must be an integer between 1 and 65536, and for UNIX and Linux must be greater than 1023.

• Run the script. prvtrsch.plb

• Set a registeration password 

4. Viewing stdout and stderr for External Jobs

Local external jobs log files 

• Directory: ORACLE_HOME/scheduler/log
• "_stdout"/"_stderr" appended to a job log id, obtain the job log ID for a job by querying the ADDITIONAL_INFO column of the "*_SCHEDULER_JOB_RUN_DETAILS"
  

DBMS_SCHEDULER.GET_FILE

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14760466/viewspace-672206/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14760466/viewspace-672206/