[Version 5.0.1 and later]Deleting Scheduler tasks

Before you begin

Use this method to remove all of your Scheduler tasks and recreate them manually.

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. Using the native database utilities, remove all of the records for each Scheduler resource for each database noted in steps 1 and 2.
    The following SQL query template can be used to remove all records. Substitute TBLPFX with the actual Table Prefix.
    DELETE FROM<TBLPFX>TASK

What to do next

Once the tasks are deleted, new tasks can be created immediately. In addition, the Scheduler service can be active while executing the DELETE SQL command in step 4. However, the operation might take longer to execute or even time out if the Scheduler has database records locked.

Related tasks
Recreating Scheduler tasks
Recreating Scheduler tables



Searchable topic ID:   tschdeletetasks
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_deletetasks.html

Library | Support | Terms of Use | Feedback