The administration console and the WASSchedulerConfiguration MBeans
provide simplified methods for creating scheduler tables and schema, verifying
that the scheduler tables and schema are setup properly and are accessible
and removing scheduler tables and schema.
When connecting to a deployment manager or node agent,
the operation attempts to verify, create or drop the tables based on the most
granular scope where the scheduler and associated data source is located.
For example, if a scheduler is configured at the server scope, the data source
at the node scope, and the verify tables operation is being run from a deployment
manager, the deployment manager attempts to connect to server1 and run the
operation there. If the server is unavailable, then it attempts to verify
at the node agent level, and then at the deployment manager level.
Note: There
are limitations when running the table management functions relating to data
source access. See the Verifying a connection topic for details on these limitations.
If a connection cannot be verified successfully, the scheduler table management
functions will fail.
Verify tables
Validates that scheduler data sources,
table prefixes, security authentication information and tables are configured
correctly. You can use this verification method in production and development
environments without altering database properties.
Create tables
Creates the necessary tables and indices
required for schedulers to operate. This method of creating scheduler tables
is designed for simple topologies and development environments. Use the supplied
scheduler data definition language files for advanced or production environments
and for databases that do not support this feature. For details, see the topic
Creating scheduler tables using the administrative console.
Draft comment:
Has
xref in this section that will be put in at a later date.
Drop tables
Specifies the removal of tables and indices
required for schedulers to operate. This method of removing scheduler tables
and indices is recommended for development environments. When you drop tables,
the action removes all previously scheduled tasks, and the scheduler no longer
operates successfully, until the tables are recreated.