Thursday, March 22, 2012

Alert forwarding - does it apply to Maintenance Plan reports?

I know that SQL Servers can be set up to forward alerts to a single
SQL Server. I am wondering if same would be true for the Maintenance
Plan Reports. Basically, I want to have only one SQL Server on the
network that has the SQL Agent Mail profile set up, and to use that
server for all e-mail and/or pager notifications for all alerts and
events raised by any of the SQL Servers on the network, including
Maintenance Plan reports. Is this possible? Is anything required to
set this up beyond alerts forwarding?

Alexey Aksyonenko"Alexey Aksyonenko" <Alexey.Aksyonenko@.coanetwork.com> wrote in message
news:1449e414.0311031137.69e3015e@.posting.google.c om...
> I know that SQL Servers can be set up to forward alerts to a single
> SQL Server. I am wondering if same would be true for the Maintenance
> Plan Reports. Basically, I want to have only one SQL Server on the
> network that has the SQL Agent Mail profile set up, and to use that
> server for all e-mail and/or pager notifications for all alerts and
> events raised by any of the SQL Servers on the network, including
> Maintenance Plan reports. Is this possible? Is anything required to
> set this up beyond alerts forwarding?
> Alexey Aksyonenko

I don't think this is possible - maintenance plans are implemented using
sqlmaint.exe, which emails the report directly to an operator. You could
investigate multiserver administration to define all jobs centrally,
although I have no idea how exactly maintenance plan reports are handled in
that environment. Or you could configure all your maintenance plan jobs to
write their reports to a single share on the 'central' server, and do
something to handle them there, such as a script to email them to an
operator defined on that server.

Simon

No comments:

Post a Comment