Creating scheduler tables using scripting and Java Management Extensions requires a database,
a Java DataBase Connectivity (JDBC) provider,
and a data source.
Before you begin
Attention: Limitations for Oracle XA databasesOracle
XA prohibits required schema operations in a global transaction environment.
Local transactions are not supported. 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.
Attention: Limitations
for DB2® z/OS® databases
Creating
and dropping tables using the administrative 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.
Procedure
- 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 remainder of these steps describe how
to create scheduler tables in an existing database.
- Launch the wsadmin tool and connect to a deployment manager or application
server.
This process requires an active server to be available and fails,
if you are disconnected from the server.
- Create a JDBC data source that refers to the scheduler
database.
- Test the data source connection.
- 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.
- Run the createTables MBean operation.
- Look up the SchedulerConfiguration object or use the
object you created in a previous step.
- Locate the WASSchedulerConfiguration MBean.
- 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 that you created reflect
the table prefix and data source specified in the scheduler configuration.
- Restart the server or start the poll daemon to run scheduler
tasks.
Results
Scheduler tables and schema are created.