InvokeSqlCommandTask
Takes as input an SQL file or an SQL command to output several CSV files that can be used by the collection.
Examples
<InvokeSqlCommandTask Identifier="SQL_Command" DisplayName_L1="SQL Command" SQLCommand="SELECT id FROM uj_jobs" Agent="Local" OpenIdClient="Job" DatabaseIdentifier="UsercubeDemo" />
Properties
| Property | Details |
|---|---|
| DisplayName_L1 required | Type: String Description: Display name of the task in language 1 (up to 16). |
| Agent optional | Type: String Description: Identifier of the agent on which the job will be launched.Note: when not specified, the task is to be launched on the server.Warning: all jobs containing the task must be launched on the same agent or on the server. |
| ContinueOnError default value: false | Type: Boolean Description: true if the execution of the Task returning an error should not stop the job machine state. |
| DatabaseIdentifier optional | Type: String Description: Identifier of the Database to connect to |
| Encoding optional | Type: String Description: Encoding for the output files. See the list of available encodings. |
| Identifier optional | Type: String Description: Unique identifier of the task. |
| IsNotAQuery default value: false | Type: Boolean Description: To know if the SQL command is a query or not |
| IsolationLevel optional | Type: String Description: Specifies the transaction locking behavior for the database connection. |
| OpenIdClient optional | Type: String Description: Connection client for the task. |
| OutputPath optional | Type: String Description: Path to save file.Alternative definition: If TaskType is:- ProvisioningPolicyTask: Path to save the LDIF file,- CollectorTask: Path of the working directory,- CollectorChangesTask: Path of the working directory,- CollectorADDirSyncTask: Path of the working directory,- ProvisionerDownloadTask: Path of the destination directory, |
| Provider optional | Type: String Description: Database provider |
| ProviderAssemblyQualifiedName optional | Type: String Description: Database provider assembly qualified name |
| SQLCommand optional | Type: String Description: SQL Command to execute |
| SQLInputFile optional | Type: String Description: Path of the SQL file |
| Timeout default value: 0 | Type: Int32 Description: Specify the timeout if the query need more 30 sec |