>when the Stock of an item in my warehouse reaches the safety stock of the reorder point I will need to send an email to specific people notifiying about the action, How do i do that?
>
>do i need to use a trigger or is there any other way, manly my question has to do with, how to use the sqlmail to send email through exchange
You can use a trigger or you can run a job on regular intervals that looks for stock that has to be reordered. In any case you should make sure that email is triggered only once. Anyway, I woul rather write data to another table and than use Sql Agent or even outside application to periodically check it and send emails out.
You can use xp_sendmail system stored procedure to send emails. There're other alternatives. Take a look at
-
http://www.sqlteam.com/item.asp?ItemID=401-
http://www.orcsweb.com/articles/sendmailsql.aspx-
http://www.sqlteam.com/item.asp?ItemID=5908
--sb--