Just migrated two databases to a new 2008 server, when I discovered something weird: You cannot choose in any way to alert operators on error in the maintenance plan. Under reports settings, there is a checkbox, but it's disabled, and I found that other users are not able to check it either. Plus it only allows you to send a report every time. Which is not what I want...
The only workaround I found applies to scheduled tasks, which I guess is reasonable - if you run the job manually, you shouldn't need an e-mail to see if it failed. SQL Server creates a job for you, that runs the task, and for jobs, you can set the Notification properties to send an e-mail.
Sunday, December 13, 2009
E-mail reporting from Maintenance tasks in SQL Server 2008
Etiketter:
alert,
e-mail notification,
job,
sql server maintenance task
Subscribe to:
Post Comments (Atom)
1 comment:
Post a Comment