Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

get specific error message alert thru email

is it possible to automate sql job to look & read specific error message,(ifpresent in err log) send an email.. either in live or scheduled?

thanks
ASKER CERTIFIED SOLUTION
Avatar of Peter Chan
Peter Chan
Flag of Hong Kong image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 25112
25112

ASKER

hi, it is not an error from within sp.. it is something that is logged in errlogs.. it has be scanned for and send an email alert.. the error in this case  is..
http://support.microsoft.com/kb/2015756
but it could be any error number that we want to filter or look for in an alert.