[Version 5.0.1 and later]Recreating Scheduler tables

Before you begin

Use this method to drop and recreate the Scheduler tables.

Steps for this task

  1. Use the administrative console to locate each Scheduler resource that was used in WebSphere Application Server Version 5.0. For each Scheduler resource, note the following:
    • JDBC DataSource JNDI Name
    • Table Prefix
  2. Use the administrative console to locate each JDBC DataSource, and note the connection and location parameters.
  3. Back up the Scheduler database.
  4. For each database and Table Prefix identified in the previous steps, execute the dropSchemaXXX.ddl and createSchemaXXX.ddl scripts located in the <install_root>/Scheduler directory of your WebSphere Application Server, where <install_root>, is the directory where the WebSphere Application Server is installed.
    Each DDL script has instructions (located at the beginning of the respective script and in the form of a comment) on how to edit and execute the script. Refer to the Creating the database for scheduler article for more information.

Related tasks
Recreating Scheduler tasks
Deleting Scheduler tasks
Creating the database for a scheduler



Searchable topic ID:   tschrecreatetables
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/scheduler/tasks/tsch_recreatetables.html

Library | Support | Terms of Use | Feedback