Oh thnx...so I'll pm you my e-mail address....really thnx alot ya

Yaya,coz task success/fail doesn't really mean my mail is sent out. But I think every mailing function have a return code indicating success/fail sending mail out, juz that I need...

Thnx Mike,i would like to hear about it....Sry to ask tat can u explain ur method in more simple way when u reply,coz im new to Microsoft SQL server 2000,and how do I set...

But the problem is I dunno how or wat the function name to call so tat it will return the code. Can u show me the function to do so?