SQL script task
A SQL script task will execute the same SQL script on several databases concurrently.
A good use case is the weekly launch of a SQL script to reclaims unused space, reorganizes indexes and tables, and defragments data files.
A SQL script task will execute the same SQL script on several databases concurrently.
A good use case is the weekly launch of a SQL script to reclaims unused space, reorganizes indexes and tables, and defragments data files.