Post reply

SQL 2005 Maintenance Plans

  • January 17, 2008 at 6:28 am

    #182810

    We recently upgraded from SQL2000 to SQL2005. Since doing this I know longer receive email notification on success or failure of maintenance plans or database backups. I have configured the Database Mail and received a successful test email, but I am still not receiving the email notification.

    Any help would be greatly appreciated.

  • January 17, 2008 at 7:08 am

    #769204

    After setting up database mail the last thing you need to do is right click on SQL Server Agent, select properties, under alert system enable the Mail profile you have set up by checking the Enable Mail Profile.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • January 17, 2008 at 7:14 am

    #769211

    The enable mail profile was checked, but I noticed the Mail system was SQLMail, so I changed this to Database Mail and selected that Mail Profile that I created...

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply