Good day all. I have about 25 SQL boxes that are 2000 and 2005. I have all the maintenance plans running successfully nightly now.
What I would like to accomplish is to have all the history reports go to one location and email a report on the failed jobs.
SQL 2005 doesn't have the option to add a remote server and then forward the reports.
SQL 2000 seems to only allow a certain number of servers to send the report (I can't get more than 14).
Any assistance, information, direction is greatly appreciated.