Home > Archive > MS SQL Server > February 2006 > Problem with Maintenance Plan sending Email report









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Problem with Maintenance Plan sending Email report
robin9876@hotmail.com

2006-02-16, 7:23 am

In SQL 2005 Maintenance Plan the logging option has been set to send a
report to an operator. However when the plan runs all the other tasks
are successful but the send report option fails and displays the
following message in the plan history.

Could not generate mail report. An exception occurred while executing a
Transact-SQL statement or batch.No global profile is configured.
Specify a profile name in the @profile_name parameter.

The SQL Server Agent has been configured to send email which the test
email is successfully sent and received. What else needs to be
configured to be able to send the report about the maintenance plan?

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com