Open topic with navigation

TIBCO GridServer® 7.1.0

# jobs

Historical information about all Services that have been run by GridServer.

Primary key: pk_jobs(job_id, start_time)

Column name | Data type | Description
| bigint not null | The Service ID
service_type_name | varchar(255) | The Service Type used for the Service
job_class | varchar(255) | The Service class being executed. For example: Java: `examples.calculator.service.JavaCalculator` Dynamic Library: `Calculator` .NET: `NETCalculatorService.dll:DataSynapse.Examples.Services.NETCalculator` Command: `ls`
start_time | timestamp not null | When the Service was started
end_time | timestamp | When the Service finished
job_status | int | Service status (see job_status_codes table)
num_tasks | int | Number of tasks in the Service
task_time_std | float | Standard deviation of task completion time, in seconds
task_time_avg | float | Mean task completion time, in seconds
priority | int | Service priority when submitted
end_priority | int | Service priority when complete
driver_username | varchar(255) | Submitting Driver user name
driver_hostname | varchar(255) | Submitting Driver hostname
job_name | varchar(255) | Optional descriptive Service name from Description
app_name | varchar(255) | Optional descriptive application name from Description
description | varchar(255) | Optional description from Description
dept_name | varchar(255) | Optional descriptive department name from Description
group_name | varchar(255) | Optional descriptive group name from Description
indiv_name | varchar(255) | Optional descriptive individual name from Description
broker_id | int | ID of Broker that ran the Service
task_time_min | bigint | Minimum task time, in milliseconds
task_time_max | bigint | Maximum task time, in milliseconds
session_size | bigint | Service Session size in kilobytes
input_size_total | bigint | Sum of task input size in kilobytes
output_size_total | bigint | Sum of task output size in kilobytes
gridlibrary | varchar(255) | The Grid Library used for this Service instance
gridlibrary_version | varchar(255) | The Grid Library version

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.