Siebel Analytics Scheduler Guide > Using Siebel Analytics Scheduler >

Changing Scheduler Table Names


You can change the names of the tables that Scheduler uses by adding settings to the Windows registry.

NOTE:  The same method of changing the registry is used under both Windows and UNIX platforms. For Scheduler installations under UNIX, before beginning the following procedure, follow the steps in Changing Scheduler Table Names Under UNIX.

Changing Scheduler Table Names Under Windows

The following procedure shows how to change Scheduler table names under Windows. For this procedure, a new key, DB Column Names, has been created as an example.

To change table names for Analytics Scheduler

  1. Run regedit and navigate to [HKEY_LOCAL_MACHINE\SOFTWARE\Siebel Systems, Inc.\Siebel Analytics\Scheduler\7.7\].
  2. Create a new key named DB Column Names.
  3. For each of the entries under the DB Column Names key, add the subkey and string values shown in the following table.
    Name
    Type
    Data

    TABLE_JOBS

    REG_SA

    S_NQ_JOB

    TABLE_INSTANCES

    REG_SA

    S_NQ_INSTANCE

    TABLE_PARAMS

    REG_SA

    S_NQ_JOB_PARAM

    TABLE_ERRMSGS

    REG_SA

    S_NQ_ERR_MSG

    The values created in the data string become the values used for Scheduler table names.

NOTE:  Changing the table names requires a restart of Scheduler.

Changing Scheduler Table Names Under UNIX

For Scheduler installations under UNIX, perform the following procedure before modifying the registry.

To change Scheduler table names under UNIX

  1. Set up the UNIX environment with the command scripts sa.sh or sa.csh.
  2. After the UNIX display is set, continue with the procedure described in Changing Scheduler Table Names.
Siebel Analytics Scheduler Guide