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.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter