You are here:

System Variables

Use system variables in conjunction with a data source in which net change is determined by a date/time stamp. When the job runs, the system variable in the source query is replaced with a value from the internal database.

The first time you use a system variable in a query, you are prompted to supply the last run date and time. Enter the information into the dialog box and click OK to proceed.

System variables can be used in a query to limit the selection to records in the source that have changed since the last time you ran the job.

Example:

Select * from address where last_mdfy_date >= :LastRunDateTime

Click Actual Query in the Configure Source dialog box to view the query syntax, based on the selected system variable, including variable substitution.

You must run the job once in the Workbench to establish a record in the execution log before you can use any system variables. All system variables use the current date/time as the default.

The following system variables are available:

:LastRunDateTime — The most recent date and time (local) that this query was executed and returned any results.
:LastRunDateTimeDTS — The most recent date and time (local) that the specified DTS was executed.
:LastRunDateTimeUTC — The most recent date and time (in GMT/UTC) that this query was executed and returned any results.
:LastRunDateTimeUTCDTS — The most recent date and time (in GMT/UTC) that the specified DTS was executed.
:PrevRunDateTimeDTS — The second most recent date and time (local) that the specified DTS was executed.
:PrevRunDateTimeUTCDTS — The second most recent date and time (in GMT/UTC) that the specified DTS was executed.
:ThisRunDateTime — The date and time (local) that this query began execution.
:ThisRunDateTimeUTC — The date and time (in GMT/UTC) that this query began execution.

Note: To process source rows that have an update stamp earlier than the current date/time, change the source query to the desired date/time. Remember to change the query back after you run the job.