WAS v8.5 > Administer applications and their environment > Welcome to administering Scheduler service > Manage schedulers > Create the database for schedulers

Create scheduler tables using DDL files

This topic provides the steps for creating scheduler tables using DDL files.

Your database system must be installed and available.

The scheduler requires a database, a Java™ Database Connectivity (JDBC) provider, and a data source.

Complete the following steps to create scheduler tables using DDL files.

1. Verify the database is created. Refer to the Creating scheduler databases topic.

2. Create the database tables according to the instructions for the database system:
   • Creating Apache Derby tables for schedulers
   • Creating DB2 tables for schedulers.
   • Creating DB2 tables for z/OS for schedulers.
   • Creating Informix tables for schedulers.
   • Creating Microsoft SQL Server tables for schedulers.
   • Creating Oracle tables for schedulers.
   • Creating Sybase tables for schedulers.

   The following scripts are deprecated, but will still work:

   Deprecated script	New script
   createSchemaDB2.ddl	createSchemaMod1DB2.ddl
   createSchemaDB2iSeries.ddl	createSchemaMod1DB2iSeries.ddl
   createSchemaDerby.ddl	createSchemaMod1Derby.ddl
   createSchemaMSSQL.sql	createSchemaMod1MSSQL.sql
   createSchemaInformix.sql	createSchemaMod1Informix.sql
   createSchemaOracle.ddl	createSchemaMod1Oracle.ddl
   createSchemaSybase12.ddl	createSchemaMod1Sybase12.ddl
   dropSchemaMSSQL.sql	dropSchemaMod1MSSQL.sql
   dropSchemaDB2.ddl	dropSchemaMod1DB2.ddl
   dropSchemaDB2iSeries.ddl	dropSchemaMod1DB2iSeries.ddl
   dropSchemaDerby.ddl	dropSchemaMod1Derby.ddl
   dropSchemaInformix.sql	dropSchemaMod1Informix.sql
   dropSchemaOracle.ddl	dropSchemaMod1Oracle.ddl
   dropSchemaSybase12.ddl	dropSchemaMod1Sybase12.ddl

Subtopics

• Create Apache Derby tables for schedulers
  This topic describes how to create tables for schedulers on Apache Derby databases, using data definition language (DDL) or structured query language (SQL) files.
• Create DB2 tables for schedulers
  This topic describes how to create tables for scheduler on DB2 databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Informix tables for schedulers
  This topic describes how to create tables for schedulers on Informix databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Microsoft SQL Server tables for schedulers
  This topic describes how to create tables for schedulers on Microsoft SQL Server databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Oracle tables for schedulers
  This topic describes how to create tables for schedulers on Oracle databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Sybase tables for schedulers
  This topic describes how to create tables for schedulers on Sybase databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Apache Derby tables for schedulers
  This topic describes how to create tables for schedulers on Apache Derby databases, using data definition language (DDL) or structured query language (SQL) files.
• Create DB2 tables for schedulers
  This topic describes how to create tables for scheduler on DB2 databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Informix tables for schedulers
  This topic describes how to create tables for schedulers on Informix databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Microsoft SQL Server tables for schedulers
  This topic describes how to create tables for schedulers on Microsoft SQL Server databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Oracle tables for schedulers
  This topic describes how to create tables for schedulers on Oracle databases, using data definition language (DDL) or structured query language (SQL) files.
• Create Sybase tables for schedulers
  This topic describes how to create tables for schedulers on Sybase databases, using data definition language (DDL) or structured query language (SQL) files.

Related

Create scheduler databases

Reference:

Scheduler table definition

+

Search Tips   |   Advanced Search