• I prefer to use SQL Server Agent output files. This way the output from the stored procedures are redirected to text files. I have an installation script that creates the objects and jobs with output files configured.

    http://ola.hallengren.com/scripts/MaintenanceSolution.sql

    Ola Hallengren

    http://ola.hallengren.com