JDBC Driver for Zendesk

Build 20.0.7587

JobStatus

A status record is created when somebody kicks off a job such as updating multiple tickets. You can access the job status data for an hour after a particular job is created, after which the data is no longer available.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the driver.
SELECT * FROM JobStatus

SELECT * FROM JobStatus WHERE Id = '123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type Description
Id [KEY] String Automatically assigned when the job is queued.
Total Integer The total number of tasks this job is batching through.
Progress Integer Number of tasks that have already been completed.
Status String The current status. One of the following: queued, working, failed, completed, killed.
Message String Message from the job worker, if any.
Results String Result data from processed tasks.
Url String The URL to poll for status updates.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587