ALTAIR SOUZA (10/6/2016)
You'll have to set a new broker, after sqlagent is stoped, run:ALTER DATABASE msdb SET NEW_BROKER WITH ROLLBACK IMMEDIATE;
In sys.databases column is_broker_enabled will be set to 1 and a new value will be set for service_broker_guid column, after restarting sql server the error will be no longer showed
Not sure anyone on the original thread is listening after 6 years but good to know. Thanks for posting.
--Jeff Moden
Change is inevitable... Change for the better is not.