Network Deployment (Distributed operating systems), v8.0 > Reference > Administrator best practices
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 dmgr 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 dmgr for example, the dmgr 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 dmgr 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. We 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 Create scheduler tables .
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.
Create scheduler tables
Create scheduler tables using scripting and Java Management Extensions
Related
Schedulers settings
API documentation