Creating Microsoft SQL Server databases for schedulers
Create Microsoft SQL Server databases for schedulers using data definition language (DDL) or structured query language (SQL) files.
About this task
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.