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 connector.

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	References	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.