Scheduler table management functions
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. 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 for example, 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.
There are limitations when running the table management functions relating to data source access. See the Verify 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. 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 Create scheduler tables using the administrative console.
Drop tables
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.
Related tasks
Reference topic