SQL Script
This class defines the settings to run a SQL script from SAF.
| Reference Information |
| Release Status : |
Stable |
| Alias Name : |
Entity.SQLScript |
| Full Reference Name : |
Collaboris.Saf.Actions.Entities.SQLScript |
| Assembly Name : |
Collaboris.Saf |
| Properties |
| Name |
Description |
Example Value |
Output |
Required |
| ConnectionString |
String. Defines the information needed to connect to SQL server.
|
Data Source=(local);Initial Catalog=msdb;Integrated Security=SSPI;
|
false
|
true
|
| ScriptFile |
String. Defines path to a file containing SQL script to run.
Note :
If both a 'ScriptFile' and 'ScripText' are supplied, both will be run. ScriptFile should be supplied like this 'C:\Temp\MyScript.SQL'
|
No example supplied.
|
false
|
false
|
| ScriptText |
String. Defines Script Text to run against the SQL Server.
Note :
If both a 'ScriptFile' and 'ScripText' are supplied, both will be run.
|
SELECT TOP 1 * from SysAlerts
|
false
|
false
|
| Timeout |
Nullable`1. Specifies the number of seconds to timeout the SQL command.
Note :
Defaults to 5000 if no value is supplied.
|
60
|
false
|
true
|