NEW!

Queue administration lets you get a list of all offline jobs queued to run in your company. You can also see a history of jobs to determine if an important offline job has been completed or if there were complications. If you have the right subscription (Premium Level of Service at Silver level or higher) you can cancel offline jobs or prioritize important jobs to the top of the queue.

An offline job refers to any sort of data action that you choose to process offline in the background while you continue working. Offline jobs can include CSV imports, contract invoices, check runs, Data Delivery Service jobs, and more. Smart Events are not currently supported.

Usage information for queue administration is available in the Sage Intacct product help.


List Offline Jobs

readByQuery

<readByQuery>
    <object>JOBQUEUERECORD</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use JOBQUEUERECORD
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'. Note: like, not like, IS NOT NULL, and IS NULL are not supported for OBJECTTYPE and OBJECTKEY.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
TIMEQUEUED Optional string Date that the job was queued in format mm/dd/yyyy
STATE Optional string Status of the job. For active jobs, use Q for Queued or T for In progress/In Transit. For processed jobs, use S for Delivered, D for Failed, R for Deferred, or C for Cancelled.
JOBTYPE Optional string Job type. Use DDS job, Asynchronous API requests, CSV import, Scheduled memorized report, Scheduled financial report, Update report, Process & store report, Scheduled report, Email report, Process & store report group, Scheduled report group, Recurring consolidation, Offline consolidation, Run action, Contract invoices, Project invoices, Check run, Confirm check run, Void check run, or Wells Fargo payments. For more information about these, see queue administration in the Sage Intacct product help.

Response

jobqueuerecord

The above function returns data structured like this:

<jobqueuerecord>
    <JOBID>6465763130WyzaiwriEQoAAEvnxBQAAAxxx</JOBID>
    <TIMEQUEUED>2018-06-22T11:21:48Z</TIMEQUEUED>
    <JOBTYPE>DDS job</JOBTYPE>
    <ACTION>Sales Document Detail</ACTION>
    <DETAILS>All data</DETAILS>
    <USERS>tjmalloney</USERS>
    <STATE>Delivered</STATE>
    <ACTIVETIME>0:05:02</ACTIVETIME>
    <WAITINQUEUE>0:49:39</WAITINQUEUE>
    <TIMESTARTED>2018-06-22T12:11:27Z</TIMESTARTED>
</jobqueuerecord>

Parameters

JOBID string Unique identifier for the job.
TIMEQUEUED string Date that the job was queued in ISO 8601 date time format.
JOBTYPE string Job type. One of DDS job, Asynchronous API requests, CSV import, Scheduled memorized report, Scheduled financial report, Update report, Process & store report, Scheduled report, Email report, Process & store report group, Scheduled report group, Recurring consolidation, Offline consolidation, Run action, Contract invoices, Project invoices, Check run, Confirm check run, Void check run, or Wells Fargo payments. For more information about these, see queue administration in the Sage Intacct product help.
ACTION string Either the name of the report or record affected by the job, or the action performed by the job.
DETAILS string Additional details of the job, which might include the record information, report information, send-to email address, or more.
USERS string User who submitted the job.
STATE string Status of the job. For active jobs, Queued or In Progress. For processed jobs, Delivered, Failed, Deferred, or Cancelled.
ACTIVETIME string Total time the job took from the start of processing to completion of processing in HH:mm:ss format (called active time in the UI).
WAITINQUEUE string Time that the job has been waiting in the queue in HH:mm:ss format.
TIMESTARTED string Date and time the job started processing in ISO 8601 date time format.

Get Offline Job

read

<read>
    <object>JOBQUEUERECORD</object>
    <keys>6465762230WuhjPAriEFQAAG91x@AAAAAK7</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use JOBQUEUERECORD
keys Required string Job JOBID to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Prioritize a Job

promote

<promote>
    <JOBQUEUERECORD>
        <JOBID>6465762230WuhjPAriEFQAAG91x@AAAAAK7</JOBID>
    </JOBQUEUERECORD>
</promote>

Parameters

Name Required Type Description
object Required string Use JOBQUEUERECORD
keys Required string Job JOBID to move to the top of the queue

Cancel a Job

cancel

<cancel>
    <JOBQUEUERECORD>
        <JOBID>6465762230WuhjPAriEFQAAG91x@AAAAAK7</JOBID>
    </JOBQUEUERECORD>
</cancel>

Parameters

Name Required Type Description
object Required string Use JOBQUEUERECORD
keys Required string Job JOBID to cancel

Provide feedback