• Super series of articles. This has helped me streamline monitoring and also learn SSIS more effectively.

    Many thanks for taking the time to contribute.

    I've found a few things that might be worth looking at:

    1. The list of Report Jobs shows "DBA-SQL Overview - Report Large Log Files" but the script to create the job has "@job_name=N'DBA-SQL Overview - Report Large Log File'"

    2. DBA-SQL Overview - Report Job Failures

    "SELECT @From=@@SERVERNAME + ''@choosebroadspire.com''"

    You actually have this in other places as well, is it just something that wasn't cleaned up?

    EDIT: I believe I know why this is here now.

    "@output_file_name=N'I:\Output\Job\DBA-SQL Overview - Report Job Failures.txt', "

    May need to be changed to an appropriate drive on the Host Server.