Show/Hide Toolbars

 

The SQL event trigger is able to monitor and Trigger upon a result value from a text or stored procedure query. The SQL Trigger supports all kind of database Connections.

 

Triggers > Add > Event Trigger > SQL > Connection sub tab

TriggerEventSQLConnection

 

 

Database Connection

Select an existing database Connection, if not existing you need to create one first. Click the Settings icon to open the Manage Connections dialog. Once a connection is added you can select it in the combo box.

 

Credential for integrated security

If your Credential requires integrated security you should select a Windows user that has access to database. Click the Settings icon to populate the drop-down list with available Credentials.

 

Command timeout

How long time before the query times out.

 

Triggers > Add > Event Trigger > SQL > Trigger > Text sub tab

TriggerEventSQLTriggerText

 

Enter the query in the text field. If you have a stored procedure - select the stored procedure tab.

 

Triggers > Add > Event Trigger > SQL > Trigger > Stored procedure sub tab

TriggerEventSQLTriggerStoredproc

 

Enter the name of the stored procedure to execute. The grid shows all parameters. When clicking on the Add button, a parameter window will open. Enter parameter values for Name, Value, Data type and Parameter direction.

 

TriggerEventSQLTRiggerStoredprocInput

 

Validate value

If this value is checked VisualCron will validate the value against the value type. Unselect this if you are using a Variable as value and this Variable is not yet set.

 

Test your SQL Task before closing the VisualCron client. Errors will be reported in the log window.

 

Triggers > Add > Event Trigger > SQL > Trigger > Condition sub tab

TriggerEventSQLCondition

 

Condition

Select the comparison method.

 

Data type

Select the result data type and the value to compare with.

 

Value to compare with

Enter a value/Variable to compare the result with. Click the Variables icon to open the the Variables list.

 

If value is the same as last time

You can control what happens if the same value comes two times in a row. By default the Trigger fire each time the Condition is met.