SQL script task

A SQL script task will execute the same SQL script on several databases concurrently.

When to use a SQL script task

A good use case is the weekly launch of a SQL script to reclaims unused space, reorganizes indexes and tables, and defragments data files.

Restrictions

Log file is populated only when a SQL script is run on a PostgreSQL database.

Task characteristics

In addition to the common task characteristics, here are those specific to SQL script tasks.

Database Set filter

Filter (by names and tags) the databases on which the sql script will be run.