Before you begin
This topic describes how to create Microsoft SQL Server databases
for schedulers, using data definition language (DDL) or structured query language
(SQL) files.Why and when to perform this task
To create a Microsoft SQL Server database for an application scheduler,
follow these steps.Steps for this task
- 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.
Result
The Microsoft SQL Server database for scheduler exists.
What to do next