October 1, 2003 at 10:06 am
How can i generate e-mail alert from SQL Server when
1. Somebody logged in (Except one user)
2. When my scheduled backup fails
any suggestions
pls help
October 1, 2003 at 11:03 am
For the backup, you need to setup an operator and SQL Mail and in the job properties, you can notify the operator when the job fails.
For the logins, you can setup an audit for a particular event (don'thave the # handy, check BOL) and then have this send an email, but that is a lot of info. Could easily overwhelm you. Not sure I'd recommend that.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 2, 2003 at 10:44 am
OK Steve, thanls very much for guiding me.
Do you have any idea from where i will get a detailed documentation on these topics, i am also searching accordingly.
anyway, thanks, thanks a lot
October 2, 2003 at 4:34 pm
BOL will have data on operators
SQLMail : http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply