Common

Automation Instruction – SQL

Use this page to Create Instructions.

To access this page:

  1. Select Common > Automation Engine > Automation Instructions in Navigation pane.
  2. Click SQL for the instruction to add the SQL code.

Field

Description

Pre Check SQL Template

Pre Check SQL

Displays SQL code used to determine if the SQL execution should precede. The Automation Engine executes the Pre Check SQL and if one or more records are returned, the statement in the SQL field will not be executed. This pre check allows a user to provide checks and control if SQL is run.

SQL Template

SQL

Displays the SQL instruction run to perform the automation step.