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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center