WAS v8.5 > Administer applications and their environment > Welcome to administering Scheduler service > Manage schedulers > Create the database for schedulers

Create scheduler tables using scripting and Java Management Extensions

Creating scheduler tables using scripting and Java Management Extensions requires a database, a Java DataBase Connectivity (JDBC) provider, and a data source.

Limitations for Oracle XA databases

Oracle XA prohibits required schema operations in a global transaction environment. Local transactions are not supported. If we 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 we use the dmgr 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.

Limitations for DB2 z/OS databases

Creating and dropping tables using the dmgr console is not supported for DB2 z/OS databases. 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.

1. Verify 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 remainder of these steps describe how to create scheduler tables in an existing database.
2. Launch wsadmin and connect to an application server. This process requires an active server to be available and fails, if you are disconnected from the server.

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 before you proceed to the next step.

6. Run the createTables MBean operation.
   1. Look up the SchedulerConfiguration object or use the object you created in a previous step.
   2. Locate the WASSchedulerConfiguration MBean.

   3. Run one of the createTables MBean operation on the WASSchedulerConfiguration object to create the tables for the specified SchedulerConfiguration object in its associated database. The tables and indices created reflect the table prefix and data source specified in the scheduler configuration.

7. Restart the server or start the poll daemon to run scheduler tasks.

Results

Scheduler tables and schema are created.

Subtopics

• Example: Using scripting to verify scheduler tables
  Use the wsadmin scripting tool to invoke a Jacl script and verify tables and indices for a scheduler.
• Example: Using scripting to create scheduler tables
  Use the wsadmin scripting tool to invoke a Jacl script and create scheduler tables.
• Example: Using scripting to drop scheduler tables
  Use the wsadmin scripting tool to invoke a Jacl script and remove scheduler tables.
• Example: Using scripting to verify scheduler tables
  Use the wsadmin scripting tool to invoke a Jacl script and verify tables and indices for a scheduler.
• Example: Using scripting to create scheduler tables
  Use the wsadmin scripting tool to invoke a Jacl script and create scheduler tables.
• Example: Using scripting to drop scheduler tables
  Use the wsadmin scripting tool to invoke a Jacl script and remove scheduler tables.

Related

Use the dmgr console
Configure a JDBC provider and data source using the JMX API
Testing a connection using wsadmin
Configure schedulers
Create scheduler databases
Start the wsadmin scripting client

Reference:

API documentation
Scheduler table definition

Related information:

Example: Using scripting to create and configure schedulers

+

Search Tips   |   Advanced Search