Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-30 : 10:41:20
|
| Orpal writes "just set up sql 2005. Added simple maintenance plans for the system and user databases, to back up nightly and delete any files older than 7 days. I would like to get an email with the results of the plan. I set up database mail, right clicked on it and "send test email" and it works fine. Added myself as an operator and linked the maintenance plan to myself as an operator. It fails. Logs an error message: Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.Incorrect syntax near 's'.Unclosed quotation mark after the character string ''. has anyone seen this before? Thanks" |
|
|
|
|
|
Sql 2005 Database Mail and Maintenance Plans