Viewing post 1 (of 1 total)
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...
October 6, 2016 at 5:08 pm
#1905293