MSSQLTips

Hi, I’m looking for a table ore stored procedure which gives me al the information about the Maintenance Plans on a SQL Server. For example Backup Folder, witch databases are selected and so. I did find a quite a lot store Procedures and some views whit information about Maintenance Plans and Jobs, bud...

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...