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

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