| projbmng.sql synchronization script

Related topics
Use this script to submit an SNP job that synchronizes Oracle Portal providers at a specified interval. The projbmng.sql script submits a job to the SNP job queue. This job calls the sync_providers procedure, which updates the remote node with node name changes, and updates the provider with changes made to the remote node's provider list. Note: If the provider synchronization job already exists, use this script to change its execution interval. projbmng.sql

| Only an Oracle Portal schema owner can submit a provider synchronization script.

Version: Oracle Portal 3.0.6.6.5 or later Deprecated: Oracle9iAS Portal 9.0.2
Prompted value:
interval | The time in minutes between the current and the next running of this job
subscriber_id | The id of the subscriber that is to run this job. If the value is left null, the job is run with the default subscriber id.
Example: To run the script: >SQLPLUS schema_name/password <Enter> >Run projbmng <Enter> >Please enter the interval for the Provider Synchronization Job (minutes): >30 <Enter> >Please enter the Subscriber ID for the job (no value will default to default subscriber): ><Enter> If the job is being submitted for the first time and if the submission is successful, these lines are displayed: >-- Job successfully submitted to job queue. >-- Portal: schema_name If the job already exists and if the submission is successful, these lines are displayed: >-- Job interval successfully modified. >-- Portal: schema_name >-- Job#: job_number If the job fails, these lines are displayed: > !!! ERROR: Failed to submit Portal synchronize job. >-- Portal: schema_name >-- SQLERR: sql_error_message

Related topics
SNP provider synchronization scripts | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio