1.3.2. Database Setup

Note: The Batch Scheduler system comes pre-configured, ready for use with the supplied demo database. If you only wish to use the demo database, then you can skip to Step 1.3.3 Testing the installation.

Use the instructions below to install the Batch Scheduler system with an other database management system.

The Batch Scheduling System requires a centrally accessible Scheduler database in order to operate.

The following will assist you in setting up the necessary Database and supporting tables for your Batch Scheduler system.

If you are setting up this system for demonstration purposes, an Access database with a sample company demo (demoschd.mdb) was installed during the installation. The system will automatically configure an ODBC datasource for the demo the first time you run one of the Batch Scheduler applications. If you want to test with multiple Agent computers, then you will need to move the demoschd.mdb file to a network drive accessible by each Agent and adjust the ODBC Datasource accordingly.

Step 1
Decide what type of database system you want to use for the Batch Scheduler database.

Access
SQL Server
Oracle
Sybase

Note: Except for Access, you must purchase a database manager system seperately, and are responsible for installing and configuring that system.

Step 2
Create the initial database using your database manager. For example: create a database named:CDSSCHED

Step 3
Have your DBA run appropriate database setup script supplied by vendor CDS. Establish a UserID in the database with Create and Update access to the scheduler database and tables. You will need to setup a UserID for each user intending to use the Batch Scheduler system.

Step 4
Setup an ODBC Datasource

Use the ODBC Data Sources manager program (typically found on your windows Start/Settings/Control Panel menu) to create a Datasource that points to the database from above.

The Batch Scheduler comes pre-configured for an ODBC Datasource named 'DEMOSCHED'. Database configuration information is stored in a file named (scheddb.cfg) located in the installation directory.

You can use the Configure Database option in the Manager program to configure additional Datasources for use with the Batch Scheduler.

Below is the ODBC Data Sources program screen.



   Index     Home