Agent Jobs

An Agent Job is a unit of work assigned to one agent. Each job has a type, a connection
configuration, an output configuration, and a trigger.

Job types

Database Query

Runs a SQL query against a database the agent can reach.

  • Drivers: MySQL, PostgreSQL, SQL Server, ODBC
  • Connection: host + port + database name + credentials, or a full connection string.
    For ODBC you can instead point at a DSN already configured on the agent machine.
  • SSL mode: defaults to the secure setting for the driver. Set to disable only if you
    have a specific reason.
  • Query: the SQL to run.

API Request

Calls an HTTP endpoint the agent can reach — typically one that isn't exposed outside your
network.

  • Methods: GET, POST, PUT, PATCH, DELETE
  • Auth: none, basic, bearer token, or API key (you choose the header name)
  • Custom headers and a request body template are supported

File Retrieval

Collects files from a directory on the agent machine.

  • Directory path and an optional file pattern (e.g. *.csv)
  • Recursive — include subdirectories (off by default)
  • Max files per run — 1,000 by default
  • Max concurrent transfers — 1 by default
  • After a successful transfer: leave the file alone, move it to another directory, or
    delete it
  • After a failed transfer: the same three options, configured separately

Move targets must be different directories from the source, or the job will re-collect
the same files on the next run.

Output

Results are written to the Intely File System, where integrations, data processor jobs
and downstream workflows can pick them up.

OptionDefaultNotes
Directoryagent-jobs/resultsWhere results land
Formatjsonjson or csv, for database queries. API responses use the format detected from the response content type
SubfoldernoneOptionally break results out by execution ID, date, or date-time
Prefix with execution IDonKeeps filenames unique across runs
On filename conflictoverwriteoverwrite, keep (both), or skip
Include manifestonRetains the run manifest alongside the data

Triggers

Manual — run on demand from the job page.

Scheduler — run once at a set time, or on a recurring schedule:

  • Hourly, daily, weekly, monthly, or a custom offset ("every N minutes/hours/days/weeks")
  • Restrict to specific days of the week, optionally qualified by which occurrence in the
    month (1st Monday, 3rd Friday, …)
  • For monthly: the first, fifteenth or last of the month
  • Constrain runs to a daily time window with run between start and end times

The job page shows the computed next run and the last run.

Execution statuses

StatusMeaning
PendingCreated, waiting to be dispatched
WaitingDispatched, queued on the agent
ExecutingRunning
SuccessCompleted
FailedStarted and errored
Dispatch FailedNever started — the agent never acknowledged the instruction
Terminating / User TerminatedA user requested a stop
System TerminatedIntely stopped it

Failed vs. Dispatch Failed is a useful distinction when triaging: Failed means your
query or endpoint has a problem; Dispatch Failed means the agent didn't pick up the work —
check the agent's connection status and the Job Dispatch logs.

Using an agent job inside an integration

The Integration Builder has an Agent Job step. Use it to run an agent job mid-workflow
and act on the result — for example, query an internal database, then map and post the rows
to an external system. See Agent Job (step).

Getting notified

Notification rules can watch agent jobs for failure, success, and no data
(the job completed but produced nothing but a manifest). See Notifications.


Did this page help you?