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,
I found the answer. Thanks1
answered May 03, 2012 at 06:35 PM