ptljbmng.sql synchronization script

Related topics

Use this script to submit an SNP job that synchronizes an Oracle Portal portlet repository at a specified interval. The ptljbmng.sql script submits a job to the SNP job queue.

Notes:

If the portlet repository synchronization job already exists, use this script to change its execution interval.

In a hosted environment, a job must be submitted for each company.

ptljbmng.sql

Only an Oracle Portal schema owner can submit a portlet repository synchronization script.

Version: Oracle Portal 3.0.8

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 subsriber ID.

Note:

The subscriber_id is only relevant when Oracle Portal is run in hosted mode.

Example:

To run the script:

>SQLPLUS schema_name/password <Enter>
>Run ptljbmng <Enter>
>Please enter the interval for the Portlet Repository 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.8
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 subsriber ID. Note: The subscriber_id is only relevant when Oracle Portal is run in hosted mode.
Example: To run the script: >SQLPLUS schema_name/password <Enter> >Run ptljbmng <Enter> >Please enter the interval for the Portlet Repository 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 portlet synchronization scripts	PDK PL/SQL API Reference - Home