send email from sql trigger

CREATE PROCEDURE dbo.mailsnd AS 
BEGIN 
    SET NOCOUNT ON 
    -- do some other actions 
    DECLARE @body VARCHAR(1024) 
    SET @body = 'foo was fired '+ 
        CONVERT(VARCHAR, GETDATE()) 
 
    EXEC master..xp_sendmail 
        @recipients='you@you.com', 
        @message = @body, 
        @subject = 'mail was fired.' 
END 
 
-- or you can do it conditionally: 
 
CREATE PROCEDURE dbo.mailsnd AS 
BEGIN 
    SET NOCOUNT ON 
    -- do some other action 
    IF @@ROWCOUNT > 0 
    BEGIN 
        DECLARE @body VARCHAR(1024) 
        SET @body = 'foo was fired ' + 
            CONVERT(VARCHAR, GETDATE()) + 
            CHAR(13) + CHAR(10) +  
            CONVERT(VARCHAR, @@ROWCOUNT) 
 
        EXEC master..xp_sendmail 
            @recipients='you@you.com', 
            @message = @body, 
            @subject = 'mail was fired.' 
    END 
END