July 31, 2006 at 8:50 am
hi,
i am working as a sql dba.i am managing more than 20 remote sqlservers from my sqlserver enterprise manager console. i have registered those servers with sa account. According to our company security policy there is no email software on those servers.and all the sql services are running under system account. now i want to be notified via a email if any jobs are failed on those servers.pls solve my problem. thanks in advance.
Regards,
thaya
July 31, 2006 at 10:32 pm
Search is your friend...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=112330
In this case Search these forums for CDOSYS
There are downloads for a SMTP email xp_ extended stored procedure, as well as roll your own examples of sending CDOSYS email from T-SQL. there are even examples for how to use the SQL Server Alert system with SMTP email.
The example above is a thread on how to include a query output as the body of the message using T-SQL & CDOSYS.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply