Executes a batch of cloud tasks.
CALL DBCloud.ExecuteTaskBatch ( sql_batch=sql_batch [, optional-parameters ] )
dbcloudcmd run ExecuteTaskBatch sql_batch [ optional-parameters ]
The SQL statements to execute, in quotes. (Required)
The cloud servers where the batch should be executed. Accepts a search query that identifies cloud servers. The search query can be a list of cloud server names or IDs separated by semicolons (;), or a full search. The default is NULL, meaning that the cloud selects a single cloud server for the task to run on. The default is NULL.
ExecuteTaskBatch allows you to run a sequence of tasks by calling the SQL task procedures. If the task batch contains one or more SELECT statements, result sets are returned up to a maximum of 100000 rows.
Do not run the FailoverToCloudPartner, ConvertCloudPartnerToServer, or ConvertServerToCloudPartner within an ExecuteTaskBatch task
The following example creates a tag named EMEA with no description set:
dbcloudcmd run ExecuteTaskBatch sql_batch="call dbcloud.CreateTag(null, 'EMEA')"
The following example creates a tag named EMEA and sets the description to Europe, Middle East, Asia:
dbcloudcmd run ExecuteTaskBatch sql_batch="call dbcloud.CreateTag(null, 'EMEA','Europe, Middle East, Asia')"