SQL Server - Scheduled query trigger

Scheduled query trigger

This trigger will execute a SQL query at a user-defined schedule. The returned rows will be processed in batches. The maximum batch size is 1000 rows.

Scheduled query trigger

Input field	Description
SQL	Provide a valid SQL string to be executed. This SQL string will be executed in your SQL Server instance.
Indexed unique key	Select a unique key column to uniquely identify rows. This list of columns will be generated from the SQL query above. Learn more here.
Batch size	Configure the batch size for this trigger. The maximum batch size is 1000 and the default is 100. If there are fewer rows than the configured batch size, this trigger will deliver all rows as a smaller batch.
Trigger on	Select the schedule configuration. Choose from Specific interval or Specific date/time.
Schedule settings	Specify how often this SQL query will be run.
Output fields	You can manually configure the output for this SQL query with this step. If left blank, the output schema will be detected automatically.

Output field

This trigger will return rows in batches. Learn more about how to work with batches of rows here.