Posted by jlaustill@gmail.com on 02/27/07 15:40

Hey yall,

I have a problem, I'm a DBA for about 250 databases. I currently have
ZERO means of notification on them. I put together an entire plan for
using SQL mail, got a pop3 account set up and all that jazz, but when
I put the request into my company to get outlook installed on my sql
servers they shut me down. The security guys said no email on servers
period even if it's outgoing only because someone might hack it. As
far as I know that's really the only way to shoot information about my
maintenance plans and other notifications I need.

So with out being allowed to use mail, can anyone suggest any means of
getting this information? I looked for a central control panel or
dashboard for sql server and couldn't find anything. It would be
really nice to have a program that could connect to all my sql servers
and just pop up an alert if something goes wrong. What I'm down to
now is just connecting to all these servers through enterprise manager
and clicking down to the jobs and checking last run status' and
checking stuff out that way, which is REALLY time consuming.

Any suggestions would be so greatly appreciated here!!!

Joshua

[Back to original message]