Oracle9iAS Portal Developer Kit

Portlet repository synchronization scripts

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

To synchronize portlet repository data you can click the Refresh link in the portlet repository or you can set up an SNP background process to refresh the data at regular intervals.

SNP background processes execute job queues. You can schedule routines to be performed periodically using the job queue. To schedule a job, you submit it to the job queue and specify the frequency at which the job is to be run. You can also alter or delete jobs you have submitted. Use ptljbmng.sql to submit the synchronization job to the job queue and to the change the job interval. Use ptlrmsyn.sql to cancel the job.

Note: For more information about SNP background processes, see Oracle8i Reference, Release 2 (8.1.6), Part Number A76961-01.

Version: Oracle Portal 3.0.8

Synchronization script name and description

ptljbmng.sql

Submits Oracle Portal repository synchronization job to the SNP job queue.

Notes:

  • If the job does not exist, run this script to submit the job.

  • If the job already exists, run this script to change the interval in which this job is run.

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

ptlrmsyn.sql

Removes the synchronization job from the SNP job queue.

 

Related topics

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