Creating application scheduler tables using the administrative console

The scheduler requires a database, a Java DataBase Connectivity (JDBC) provider and a data source.

Before you begin

Note: Limitations for Oracle XA databases
Oracle XA prohibits required schema operations in a global transaction environment and does not support local transactions. If you have schedulers that use an Oracle XA data source, either temporarily change the scheduler configuration to use a non-XA Oracle data source, or create the tables manually using the supplied DDL files. If you use the administrative console to create or drop scheduler tables for a scheduler configured to use an Oracle XA data source, then you receive a SchedulerDataStoreException error message, and the operation fails.
Note: Limitations for DB2 z/OS databases
DB2 z/OS databases do not support creating and dropping tables through the administrative console. A database administrator is typically involved with defining and managing databases on DB2 z/OS systems. The administration interface is targeted for the non-database administrator or developer who does not want to know the specifics of setting up the scheduler database. The scheduler has DDL files available for the database administrator to create the required tables.

Why and when to perform this task

Make sure that the database you need has been created.

Steps for this task

  1. Verify that the database to be used for this scheduler is available and accessible by the application server. Review the Creating scheduler databases and tables topic for instructions on creating a database. The remaining steps describe how to create scheduler tables in an existing database.
  2. Start the administrative console.
  3. Create a JDBC data source that refers to the scheduler database.
  4. Test the data source connection.
  5. Create a scheduler. This configuration object contains the desired table prefix and the JNDI name of the JDBC data source. Verify that you save the new Scheduler to the configuration repository before you proceed to the next step.
  6. Select Resources > Schedulers to view all defined schedulers.
  7. Select one or more schedulers.
  8. Click Create Tables to create the tables for the selected schedulers in their associated database. The tables and indices you created reflect the table prefixes and data sources specified in each scheduler configuration.
  9. Restart the server or start the poll daemon to run scheduler tasks.

Result

Application scheduler and schema are created.

What to do next


Copyright IBM Corp. 2003, 2005 |