* 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 |
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. |