Use this method to drop and recreate the Scheduler tables.
Steps for this task
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
Use the administrative console to locate each JDBC DataSource,
and note the connection and location parameters.
Back up the Scheduler database.
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.
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