variables field and resolved when the job is submitted.
Variable types
param
User-provided values passed at submission time:param variables must be provided when the job is submitted. Optional variables use the default value when omitted.
dateOffset
A date relative to the submission time:days: -30 resolves to an ISO date string 30 days before submission. days: 0 resolves to the current date.
now
The current ISO timestamp at submission time:Using variables
Reference variables with{{var.variableName}} syntax.
In service params:
Variables in SQL queries are automatically parameterized to prevent SQL injection and formatting issues.
Template syntax
Both can be used together in the same step:
Submitting with variables
When submitting a job programmatically, pass variable values in theparams object:
schedules.json:
Variables with
type: "dateOffset" and type: "now" are resolved automatically — you don’t pass values for them at submission time.
