Set Up Parameterized Submissions
The Parameterized Submission process (PSUB) schedules and runs jobs, reports, and batch processing for Oracle Clinical. In order to support using Oracle Real Application Clusters (RAC), the implementation of PSUB changed in Oracle Clinical 5.0.
You must start one PSUB service for each Oracle Clinical database on the same server as the database.
For more information, see:
- Create Directories and Enter Values in OCL_STATE Local Reference Codelist
- Enable Users to Submit PSUB Jobs
- Enable opapps to Use the at Command
- Start the PSUB Service
- Customize the PSUB Service (Optional)
- Test the PSUB Installation
Parent topic: Install Oracle Clinical Database Components on UNIX
Create Directories and Enter Values in OCL_STATE Local Reference Codelist
Note:
See Integrate SAS (Optional) for information about new OCL_STATE settings related to SAS configuration.Parent topic: Set Up Parameterized Submissions
Enable Users to Submit PSUB Jobs
Beginning in Release 5.0, PSUB users no longer need:
- their own OS account
- a user name beginning with
OPS$
- their own directory for PSUB outputs under their own OS account home. (Instead PSUB outputs are stored temporarily in a user specific directory under PSUB root folder specified inPSUB_LOGS_DIR entry of the OCL_STATE local reference codelist. Then they are uploaded into database and can be viewed.)
New Users
To add new users:
- Use the ocl_add_user.sql script, indicating which new users need to run PSUB jobs.
See the Oracle Clinical Administrator's Guide for more information.
Existing Users
If you are upgrading from a pre-5.0 version of Oracle Clinical, to give users who need to run PSUB jobs access to the opapps account:
PSUB Administrator User
You can give a user the role RXC_VWJOBS (new in 5.0) to allow him or her to:
- View all users' jobs
- View the output from those jobs.
- Stop any job.
The following scripts can grant this role to a user:
- ocl_add_user—Use this script for new users.
- ocl_grant_revoke_rxc_vwjobs.sql—Use this script for existing users. (This script can also be used to revoke the role.)
See the Oracle Clinical Administrator's Guide for more information.
Parent topic: Set Up Parameterized Submissions
Enable opapps to Use the at Command
To use the at command to schedule jobs on behalf of another user, the owner’s user account must be listed in the at.allow file. The owner is opapps.
To edit the at.allow file:
Parent topic: Set Up Parameterized Submissions
Start the PSUB Service
The Installer automatically installs the PSUB service on the database server. You must start it using on set of instructions below.
Instructions for stopping PSUB manually are included in the Oracle Clinical Administrator's Guide.
To start the PSUB service on UNIX:
Parent topic: Set Up Parameterized Submissions
Customize the PSUB Service (Optional)
For more information about managing and customizing the PSUB service, see the Oracle Clinical Administrator's Guide.
Parent topic: Set Up Parameterized Submissions
Test the PSUB Installation
To test your PSUB installation:
- Open Oracle Clinical.
- Submit a 3GL job such as Batch Validation or a PL/SQL job such as Study Unfreeze.
- Verify that Oracle Clinical creates the log and output files by clicking on the View log and View output buttons.
If you encounter problems or errors, review the messages in the PSUB log files created in the following directory:
$RXC_ROOT/log
Parent topic: Set Up Parameterized Submissions