WAS v8.5 > Reference > Administrator best practicesScheduler table management functions
The administration console and the WASSchedulerConfiguration MBeans provide simplified methods for creating scheduler tables and schema, verifying the scheduler tables and schema are setup properly and are accessible and removing scheduler tables and schema.
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. 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
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.
Related
Create scheduler tables
Create scheduler tables using scripting and Java Management Extensions
Reference:
Schedulers settings
API documentation