Is there any SMS alert provision in Yahoomail ?

If you have a blackberry you can sync your email to it. But other than that I do not know, I would try finding an app if your phone can get those.