Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Task syntax

ExecuteTaskBatch task

Executes a batch of cloud tasks.

Syntax 1 (SQL)
CALL DBCloud.ExecuteTaskBatch ( sql_batch=sql_batch [, optional-parameters ] )
Syntax 2 (Cloud Command utility)
dbcloudcmd run ExecuteTaskBatch sql_batch [ optional-parameters ]
Parameters
  • sql_batch

    The SQL statements to execute, in quotes. (Required)

  • server_list

    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.

Required privileges

ExecuteSQL

Remarks

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

Example

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')"