Extender 2016

Run SQL Script (Enterprise Only)

* This feature is only available in Extender Enterprise. *

 

A Run SQL Script action type executes a SQL script inside any of the databases on your SQL Server.

 

To add a Run SQL Script action type:

1.Select the event from the Events list that you want to add a Run SQL task to
2.Click on the Add button next to the Actions list and select Run SQL Script from the drop-down list

Form Run SQL Script Action

 

3.Enter a Description for the action type.
4.Select the Company that you want run the SQL script in.  This can be a Microsoft Dynamics GP company or the system database.
5.Enter the SQL script that you want to run.  Parameters and Tables can be selected from the list on the right.
6.Click on the Save button.