x

Database mail failed to send email to operator

I get the following error message for a multi-server job. the dbmail works fine. It looks like the job is not nififing the MSXOperator.

dbmail is configured on both the master and target server.

thanks for any suggestions. If you need more information just let me know.

05/03/2012 12:00:00,Trans Log bhmcs1.Subplan_1 (Multi-Server),Success,0,BHMCS1,Trans Log bhmcs1.Subplan_1 (Multi-Server),(Job outcome),,The job succeeded. The Job was invoked by Schedule 110 (Trans Log bhmcs1.Subplan_1). The last step to run was step 1 (Subplan_1). NOTE: Failed to notify 'MSXOperator' via email.,00:00:03,0,0,,,,0, 05/03/2012 12:00:00,Trans Log bhmcs1.Subplan_1 (Multi-Server),Success,1,BHMCS1,Trans Log bhmcs1.Subplan_1 (Multi-Server),Subplan_1,,Executed as user: MCLEOD\sqladmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:00:00 PM DTExec: The package execution returned DTSER_SUCCESS (0). Started: 12:00:00 PM Finished: 12:00:02 PM Elapsed: 1.125 seconds. The package executed successfully.
> The step succeeded.,00:00:03,0,0,,,,0,
more ▼

asked May 03, 2012 at 05:37 PM in Default

clayp56 gravatar image

clayp56
71 9 9 10

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
I found the answer. Thanks1
more ▼

answered May 03, 2012 at 06:35 PM

clayp56 gravatar image

clayp56
71 9 9 10

can you post the answer so future visitors can benefit?
May 03, 2012 at 07:19 PM KenJ
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x29

asked: May 03, 2012 at 05:37 PM

Seen: 971 times

Last Updated: May 03, 2012 at 07:19 PM