Service Broker message delivery is not enabled in this database. Use the ALTER DATABASE statement (4297940)

Error displayed in LiteSpeed 6.1.1 maintenance plan history:
Executed as user: Domain_name\username. ...r Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:18:45 AM Progress: 2011-12-23 08:18:46.48 Source: {8151B158-3EAF-4F9D-8C7A-95168DDB942B} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma".: 100% complete End Progress Error: 2011-12-23 08:18:57.96 Code: 0xC002F210 Source: Notify Operator 1 Execute SQL Task Description: Executing the query "use [msdb] execute msdb.dbo.sp_send_dbmail @recipients = N'user.name@quest.com',@subject = N'Subject line here',@body = N'Body of the message' " failed with the following error: "Service Broker message delivery is not enabled in this database. Use the ALTER DATABASE statement to enable Service Broker message delivery. Changed database context to 'msdb'.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:18:45 AM Finished: 8:19:07 AM Elapse. The step failed.
 

Message Service Broker was not enabled for MSDB.

The message “Service Broker message delivery is not enabled in this database” refers to the msdb, NOT the user database being backed up. To enable message service broker:

USE master ;
GO
ALTER DATABASE MSDB SET ENABLE_BROKER ;
GO
 

Note: The Agent has to be stopped in order to update the msdb in sys.databases.