THis is a quick and easy way to send messages that relies on email.

CREATE PROCEDURE [dbo].[sp_sendAlert]

@From varchar(100),

@To varchar(100),

@Subject varchar(100),

@Body varchar(4000),

@cc varchar(100) = null,

@BCC varchar(100) = null

AS

Declare @MailID...

Have you verified the database connection to make sure that the DB server is responding?