By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,948 Members | 1,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,948 IT Pros & Developers. It's quick & easy.

Alert forwarding - does it apply to Maintenance Plan reports?

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Alexey Aksyonenko" <Al***************@coanetwork.com> wrote in message
news:14**************************@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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.