I would like the last step of my Maintenance Plan to execute a simple custom SQL script (
SELECT * FROM <SomeTable> WHERE <Condition>), and save the results to a file (Text, CSV, etc).
Is this possible? The closest thing I've found is doing this in a
.bat file that is executed by Windows, but that seems a little cumbersome.