question

clayp56 avatar image
clayp56 asked

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,
dbmail
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
clayp56 avatar image
clayp56 answered
I found the answer. Thanks1
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

can you post the answer so future visitors can benefit?
2 Likes 2 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.