| 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

Related topics
SNP portlet 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