x
login about faq Site discussion (meta-askssc)

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: MCLEODsqladmin. 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 '12 at 05:37 PM in Default

clayp56 gravatar image

clayp56
71 6 8 8

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

1 answer: sort voted first

I found the answer. Thanks1

more ▼

answered May 03 '12 at 06:35 PM

clayp56 gravatar image

clayp56
71 6 8 8

can you post the answer so future visitors can benefit?

May 03 '12 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.

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x28

asked: May 03 '12 at 05:37 PM

Seen: 466 times

Last Updated: May 03 '12 at 07:19 PM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.