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 » Tasks and events

Running batches of SQL statements at tenant databases

Run batches of SQL statements on tenant databases in the cloud.

Prerequisites

You must have the ExecuteSQL privilege.

Context

Not all SQL statements are supported.

Procedure

  1. In the Cloud Console, navigate to the Events panel.
  2. Click Run new task.
  3. Select ExecuteTenantBatch.
  4. Click Next.
  5. In the database_list field, specify the database that you want to run the SQL statements on.

    For example:tenant1.

  6. In the sql_batch field, paste the tasks that you want run.

    For example:

    CREATE STATISTICS ON DBO.RowGenerator;
  7. Click Finish.

Results

The ExecuteTenantBatch task runs on the database.