storagepool purge argument: Delete storage pool entries (SQL administration API)

Use the storagepool purge argument with the admin() or task() function to delete all storage pool entries, storage pool entries that have a status of Full, or storage pool entries that have a status of Error.

EXECUTE FUNCTION { admin | task } ( { "storagepool purge all" | "storagepool purge full" | "storagepool purge errors" | ); }

Usage

Use the storagepool purge all argument to delete all entries in the storage pool.

Use the storagepool purge full argument to delete all storage pool entries that have a status of Full.

Use the storagepool purge errors argument to delete all storage pool entries that have a status of Error.

The storagepool table in the sysadmin database contains a column that shows the status of each entry in the storage pool.

Example

The following command deletes all storage pool entries that have a status of Full:

EXECUTE FUNCTION task("storagepool purge full");