To create
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 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.
Note: 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 remaining steps describe how to create scheduler tables in an
existing
database.
- Start the administrative console.
- 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
repository
before you proceed to the next step.
- Click Resources > Schedulers to
view all defined
schedulers.
- Select one or more schedulers.
- 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.
- Restart the server
or start the poll daemon to run scheduler tasks.
Results
Scheduler tables and schema are created.