Create Microsoft SQL Server databases
for schedulers using data definition language (DDL) or structured
query language (SQL) files.
About this task
To create Microsoft SQL Server databases
for schedulers, using data definition language (DDL) or structured
query language (SQL) files, use these steps.
Procedure
- Make sure that you are using a user ID that has administrator
rights for the database system.
- In the Enterprise Manager, expand a server group,
then expand a server. A Microsoft SQL
Server database named scheddb is created.
- Right-click Databases, then click New Database.
- Verify that the database supports Unicode (UTF-8). Otherwise, the database does not store all characters that can
be handled in the Java code, which results in code
page conversion problems, when a client uses an incompatible codepage.
- Type the name scheddb.
- Modify any default values, and save your changes. The Microsoft SQL Server database,
scheddb, is created.
Results
The Microsoft SQL Server database
for scheduler exists.