If you’ve ever moved MSDB and have notifications setup using DatabaseMail then you probably already know what I (re)learned today.
If you move MSDB your notifications will stop working. Why you may ask?
It’s because the ENABLE_BROKER configuration is set to false when you move MSDB. Now I can’t seem to find (google) any information as to WHY this is (please send comments if you have further info) but in order to get your notifications up and running again you’ll need to run the following command:
ALTER DATABASE msdb SET ENABLE_BROKER;
If this takes a while to run then chances are you are being blocked by another process (chances are the SQL Server Agent)
If you’re interested in reading more here is the Microsoft BOL Link on moving system databases.
Enjoy!!
