Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Administering: Running Database Scripts Automatically
 

Classic Java CAPS

Managing Java CAPS Users

Using LDAP with Java CAPS

Administering the Sun Business Process Manager Database

Creating the Monitoring and Recovery Database

Creating the Database Instance

Running the Scripts in Enterprise Designer

Running the Database Scripts from a Local Directory

Running Database Scripts Automatically

To run the scripts automatically

Purging and Archiving Sun BPM Data

Installing the Purge and Archive Database Components

Archiving and Purging by Retention Days

Archiving and Purging by Business Process Name

Archiving and Purging by Application Name

Using the Sun Business Process Manager Worklist Manager for User Activities

Maintaining Sun Master Indexes (Repository)

Working With the EDM for Sun Master Patient Index

Working With the EDM for Sun Master Index

Java EE Based Components

Working With the Master Index Data Manager

Maintaining Sun Master Indexes

Analyzing and Cleansing Data for Sun Master Index

Loading the Initial Data Set for a Sun Master Index

Running Database Scripts Automatically

You can choose to run the database scripts automatically when you deploy a Project to a server. Scripts can be automatically run for both the monitoring and recovery database and for the Business Process reporting tables.

To run the scripts automatically

  1. Create the database instance, as described in Creating the Database Instance.
  2. Modify the monitoring and recovery database scripts and define the database connection properties, as described in Running the Scripts in Enterprise Designer (but do not run the scripts).
  3. Configure the Business Processes in the Project for persistence and configure the database connection properties (but do not run the scripts).
  4. Configure the Sun BPM Engine for persistence. Set Automatic Execution of Database Scripts to true.
  5. When you deploy the Project, the scripts are run automatically for the monitoring and recovery database and for each Business Process configured for persistence.