Open topic with navigation

TIBCO GridServer® 7.1.0

# Configuring Scheduler Instrumentation

The GridServer Manager can use the `scheduler_info` table, which contains details of GridServer Scheduler operations.

## Scheduler Instrumentation Requirements

To configure a database for Scheduler Instrumentation, you must have a supported third-party database. For a list of supported databases, see the readme file included with TIBCO GridServer®.

## To configure Scheduler Instrumentation

To configure Scheduler Instrumentation, you must perform the following steps:

| 1. | Install the GridServer Manager and GridServer Engine

| 2. | Task A Configure the Database

| 3. | Task B Configure the Manager (to use the database)

| 4. | Restart the Manager (The JDBC JAR file is picked up by the Manager only after a restart.)

## Task A Configure the Database

Create the `scheduler_info` table in any supported database (Oracle, PostgreSQL, MSSQL). Refer to the syntax provided in the `scheduler-info-readme`, available in the `DS_MANAGER/webapps/livecluster/WEB-INF/etc/db` directory.

## Task B Configure the Manager

1. Log in to the GridServer Administration Tool with an account that has a Security Role with the Manager Configuration Edit feature enabled.

2. Go to Admin > System Admin > Manager Configuration > Services > Scheduler Tracker.

3. Configure the values in the Scheduler Tracker section on Broker by using the appropriate values given in the following table:

   Note that the `hostname` is the name of the host and `dbName` is the name of the database.

   Property | Value
   --- | ---
   Oracle |
   Database URL | jdbc:oracle:thin:@hostname:1521/dbName
   Database Driver | oracle.jdbc.OracleDriver
   Microsoft SQL Server |
   Database URL | jdbc:sqlserver://hostname:1433;DatabaseName=dbName; SelectMethod=cursor (SelectMethod=cursor is required)
   Database Driver | com.microsoft.sqlserver.jdbc.SQLServerDriver
   PostgreSQL |
   Database URL | jdbc:postgresql://hostname:5432/dbName
   Database Driver | org.postgresql.Driver

4. Copy the corresponding JDBC driver's JAR file to the following Manager's directory: `DS_MANAGER/webapps/livecluster/WEB-INF/lib`.

5. Restart the Gridserver Manager.

To view the data, you require an account that has Security Role with the Scheduler Instrumentation feature enabled. The data can be viewed from the UI at Diagnostics > Scheduler Instrumentation on the Broker.

Level 1

Level 2

Level 3

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO GridServer®

Copyright © 2001-2022. TIBCO Software Inc. All Rights Reserved.