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

DeleteOldCloudTransactionLogs task

Deletes cloud transaction logs that are older than a specified age.

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

    The servers from which old logs are deleted. 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. (Required)

  • max_days

    The maximum number of days to retain cloud transaction logs. The default is 7.

Required privileges

Administrator

Remarks

By default, this task runs as a nightly scheduled task.

Example

Run the following task to delete cloud transaction logs older than 3 days on the cloud server named myserver#2:

dbcloudcmd run DeleteOldCloudTransactionLogs server_list="myserver#2" max_days=3

Run the following task to delete cloud transaction logs older than 5 days on all cloud servers that have a current status of running:

dbcloudcmd run DeleteOldCloudTransactionLogs server_list="status:running" max_days=5