8 Managing Batch Jobs

8.5.1.1 Starting PSUB Manually in UNIX

To start the PSUB service on UNIX:

1. Log in as the opapps user. By default, the opapps uses the C shell.

2. Set environment variables for the database name and code environment; see "Setting Environment Variables on the Command Line."

3. Start the PSUB service:

   start_psub database_name code_environment wallet_alias

   For example:

   start_psub prod 52 prod

   where prod is the connect string for the database instance to which the PSUB service connects;

   where 52 is the name of the code environment;

   where wallet_alias is the name of the Wallet specified during installation. By default it is the same as the database name.

4. If there are any errors, check the following log files in the $RXC_CENTRAL_LOG directory:

   • rxcpsd_instance_environment_1.log

   • rxcpsd_instance_environment_2.log

8.5.1.2 Stopping PSUB Manually in UNIX

The preferred way to stop the PSUB service is with the following utility, from the opapps account, after setting the correct environment. You need to be sure the TNS_ADMIN environment variable is set to the location of the sqlnet.ora file. The Installer puts sqlnet.ora in the opapps Home directory; see "Setting TNS_ADMIN on UNIX".

Use the echo command to check the setting, then stop PSUB.

echo $TNS_ADMIN
setenv TNS_ADMIN $HOME
stop_psub database_name][environment Wallet_alias

8.5.2.1 Starting PSUB Automatically in UNIX

The following example shell scripts for Sun Solaris show how to make the process start automatically at system startup:

# File: /etc/init.d/dbora
ORA_HOME=/u01/app/oracle/product/12.1.0.2
ORA_OWNER=oracle 
if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
then
   echo 'Oracle startup: cannot start'
   exit
fi
case "$1" in
'start')
echo 'Starting Oracle...'
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
su - $ORA_OWNER -c "lsnrctl start"
su - opapps -c start_psub
;;
'stop')
echo 'Stopping Oracle...'
su - opapps -c stop_psub 
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
;;
esac
# File: start_psub
# Start database 1
start_psub db_name1 code_environment wallet_alias
# Start database 2
start_psub db_name2 code_environment wallet_alias

For example:

# Start database 1
start_psub venus 52 wallet_alias
# Start database 2
start_psub pluto 52 wallet_alias

where the database names are venus and pluto and you have installed Oracle Clinical 5.2.

8.5.2.2 Stopping PSUB Automatically in UNIX

You can automate the shutdown of the PSUB service on UNIX so that it does not require the entry of a password.

The following example shell scripts for Sun Solaris show how.

# File: /etc/init.d/dbora
ORA_HOME=/u01/app/oracle/product/12.1.0.2
ORA_OWNER=oracle 
if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
then
  echo 'Oracle startup: cannot start'
  exit
fi
case "$1" in
'start')
echo 'Starting Oracle...'
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
su - $ORA_OWNER -c "lsnrctl start"
su - opapps -c start_psub
;;
'stop')
echo 'Stopping Oracle...'
su - opapps -c stop_psub 
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
;;
esac
# File: stop_psub
# Stop database 1
set TNS_ADMIN= opapps_home_dir
export TNS_ADMIN
stop_psub venus 52 wallet_alias
# Stop database 2
stop_psub pluto 52 wallet_alias

where the database names are venus and pluto and you have installed Oracle Clinical 5.2.

8.5.3.1 Installing PSUB in Windows

On Windows, you must first install the PSUB process as a service:

1. Log in to the Windows server as Administrator or as a user with administrative privileges.

2. Open a Command Prompt window:

   • If you logged in as Administrator, click Start, then Run, then enter cmd.

   • If you logged in as a different user with administrative privileges, click Start, type cmd in the Start search box, then right-click cmd in the list and click Run as administrator.

3. Enter the following commands:

   set p1=database-connect-string
   set p2=code-environment
   opa_setup
   cd %RXC_BIN%
   rxcpsdps -install database-connect-string database-instance-name
   

4. Navigate to Start, then Administrative Tools, then Services.

5. In the Services window, right-click on the PSUB service, then click Properties. The PSUB Service Properties window opens.

6. In the General tab, set the Startup Type to Manual.

7. In the Log On tab, select This Account, then click Browse.

8. Enter: opapps, then click Check Names. The system enters the relative location to opapps.

9. Click OK. The system returns to the PSUB Service Properties window.

10. Enter and confirm the opapps password, and click OK.

11. Log out from this Administrator session.

8.5.3.2 Starting PSUB Manually in Windows

To start the PSUB service on Windows:

1. Log in as opapps. (You set up the PSUB service to start as the opapps user, but in Windows you can start the service when logged on as another user.)

2. Set the PSUB service parameters:

   1. In the Start menu, navigate to Administrative Tools, then Services.

   2. From the list of services in the Services dialog box, double-click the name of the database for this service. It is in this form:

      PSUB Service database

   3. Enter values for the Log On parameters:

      database code_environment [verbose | noverbose] value-of-RXC_ROOT wallet_alias

      For example: prod 52 verbose c:\\opapps\\oc\\52 <Wallet_name>

      where prod is the connect string for the database instance to which the PSUB service connects;

      where 52 is the name of the code environment;

      where wallet_alias is the name of the Wallet specified during installation.

      Note:

      If your entry requires a backslash (\), you must enter two (\\). Alternatively, you can enter the path using single forward slashes, for example, c:/OPA_HOME/oc/52.

3. Click Start.

4. Exit from the Services dialog box.

5. Check the PSUB service log file in <RXC_ROOT>/log for any warning or error messages.

8.5.3.3 Stopping PSUB Manually in Windows

Do not use Enterprise Manager to stop opapps sessions on Windows; instead, use the Control Panel on the appropriate local machines.

To stop the PSUB service:

1. Log in as the PSUB user; in this case, opapps.

2. Open the Services control panel.

3. In the Services dialog box, select the PSUB service for the particular database and open the Properties window. The PSUB service for the venus database, for example, might appear as:

   psub service venus
   

4. In the Properties window, click Stop.

8.5.4.1 Creating a System Environment Variable

You can specify that the PSUB service starts automatically when the Windows PSUB server re-boots. The service parameters are read from a system environment variable whose name concatenates PSUBSERVICE with the database name.

To create a system environment variable in Windows:

1. Navigate from Start to the Control Panel, then click on the System and Security link. The System and Security window opens.

2. Click the System link. The System window opens.

3. Click the Advanced System Settings link at the top left corner. The System Properties window opens.

4. Select the Advanced tab, then click Environment Variables.

5. Click New under System Variables in the lower portion of the window to define the variable.

   For the variable name, enter the string PSUBSERVICE concatenated with the database name; for example, for the database sun6x2:

   PSUBSERVICESUN6X2

   For the variable value, use the format: database_id code_environment verbose RXC_ROOT wallet_alias; for example:

   pluto 52 verbose t:\\opapps\\oc\\52 wallet_alias

   where pluto is the database ID and RXC_ROOT is t:\opapps\oc\52.

   Note that if you need a backslash (\) in the text box, you must double it (\\).

8.5.4.2 Creating a Batch File

Create a batch file called 'psub_start1.bat' in the %RXC_ROOT%/log directory (for example, D:\opapps\oc\52\log) with the following contents.

cmd /c echo Current Date/time= %DATE% %TIME% > psub_start1.log 
cmd /c echo Starting Time Delay > psub_start1.log
ping localhost -n 180 > nul 
cmd /c net start "PSUB Service database_id" > psub_start1.log 

Notes:

• "PSUB Service database_id" is the PSUB service name that appears in the Services window (under Administrative Tools from the Control Panel).

• You can repeat the following command for different databases if needed:

  cmd /c net start "PSUB Service database_id" > psub_start1.log 
  

• The 'ping localhost' command introduces a time delay to ensure that the database is up before starting PSUB. You can increase this value—set to 180 seconds (3 minutes) in the example above—if required.

8.5.4.3 Scheduling the Batch File and Testing the Setup

To schedule batch file execution:

1. Navigate to Start, then Administrative Tools, then Services. Scroll down and make sure that the Task Scheduler service is started.

2. Navigate to Start, then Administrative Tools, then Task Scheduler. The Task Scheduler window opens.

3. Click the Create Basic Task link on the right. The Create Basic Task wizard appears.

4. Enter a Name and Description and click Next.

5. In the Task Trigger window, select When the computer starts and click Next. The Action window appears.

6. In the Action window select Start a program and click Next. The Start a Program window appears.

7. In the Start a Program window, click Browse. The Browse window appears.

8. In the Browse window, browse to the directory where psub_start1.bat is saved and then select psub_start1.bat. Leave the other boxes empty and click Next.

9. Select Open the Properties dialog for this task when I click Finish and click Finish. The Properties dialog box opens.

10. In the Properties dialog box, General tab, Security options section, click Change User or Group and select Administrator.

    To test, shut down the service if necessary (see "Stopping PSUB Manually in Windows") and double-click on file psub_start1.bat to test that it starts the PSUB service. Verify that the log file psub_start1.log is created in the same directory unless a different path was specified.

11. In the Services window under Administrative Tools in the Control Panel, right-click the PSUB Service, click Properties, and change its Startup Type to Manual.

    To test, restart the computer and check the Services window to see if the PSUB service has started. If it has, submit a PSUB job such as Batch Validation and check if it runs.

8.5.4.4 Adding a Shortcut

For convenience add a shortcut for psub_start1.bat on the desktop to manually start PSUB by double-clicking the icon.

8.6.4.1 Viewing Logs that Concern Execution of PSUB Processes

The PSUB service writes to log files pointed to by the variable RXC_CENTRAL_LOG. RXC_CENTRAL_LOG is defined as $rxc_root/log (on UNIX), or %rxc_root%\log (on Windows). Do not redefine this variable to any other values.

However, the following file can be read while the PSUB service is running:

If the process is running in verbose mode more information is written to the log file. You cannot switch from non-verbose to verbose modes while the process is running; you must stop and restart the process to switch mode.

8.6.4.2 Viewing Logs for Individual PSUB Jobs

Log and output files are always placed in the log directory in your home directory on the server on which PSUB is running. You cannot update log and output file names. The names of the files are structured such that the unique batch job ID for the job is given an:

• "l" prefix for the log file

• "o" for the output file.

For example, a batch job ID of 12345 would have an output file name of:

• $RXC_LOG/user/o12345.out (for UNIX)

• %RXC_LOG%\o12345.out (for Windows)

and a log file name of:

• $RXC_LOG/12345.log (for UNIX)

• %RXC_LOG%\12345.log (for Windows)

To view the output or log file on the screen, click the View Output or View Log button and enter the relevant information in the window.

8.6.4.3 Printing Output or Log Files

To print the output or log file, press the Print Output or Print Log button. In the pop-up box, specify the printer.

For printing, PSUB uses the standard lp command (on UNIX) or print functions (on Windows). No other environment variables control printing.

Printing from PSUB jobs on a UNIX server to a Windows spooler is not supported.

8.6.5.1 Create a Job Set

1. Save a parameter set for each job to be included in the job set, if that has not been done already.

2. Select Admin, then PSUB Jobs, and Job Sets.

3. Enter a name for the job set (alphabetic characters only).

4. In the Job Label field, enter a short name for the first job in the sequence. You use this name in the fields under JOB LABEL to the right.

   Note:

   No jobs included in a job set can have a LOCAL_IMMEDIATE mode of execution

5. Enter the name of the saved parameter set for the job. list of values available.

6. Set the timeout limit for the job in minutes. Default: 720 (12 hours).

7. The next three fields set the execution order and conditional branching. Enter the job label for the job you want to run next if the current job runs successfully, fails, or times out. If you leave one of these fields blank, the entire job set will stop executing if the current job has the corresponding result. For example, if you leave the Failure field blank and the current job fails, Oracle Clinical stops executing the entire job set.

Oracle Clinical enters the task name for the parameter set you entered.

Repeat this process for each job in the job set.

8.6.5.2 Submit a Job Set

1. Select Admin, then PSUB Jobs, and Submit Job Set.

2. Enter a job set name. An list of values is available.

3. Click Submit Job.

A job set controls the execution order for a specified set of jobs, so that jobs that depend on other jobs will execute only if the jobs on which they depend have been successfully executed. If any of the jobs in a job set exits with a status of SUBMIT-FAILED or STOPPED, the whole job set aborts with a status of FAILURE. You create job sets by selecting Admin, then PSUB, and Job Set.