> @recipients = 'Toyouradresse@yourdomain',
> @subject = 'Test',
> @message = 'If you don´t see this message it doesn´t work'

> Hi All,
>
> Recently my automated email sp has stopped working, I have attached the
> code
> below, I don't really think it is the sp but was wondering what else could
> make this job not work all of a sudden.
>
> When run it just runs and runs and runs, usually it used to take around 1
> second.
>
> I have restarted the SQL Server Agent with no luck.
>
> Cheers
> David
>
> ---------------------------------------
>
> CREATE PROCEDURE spr_Email_DataTransferComplete
>
> @OutRetVal INT OUTPUT
>
> AS
>
>
> DECLARE @srecipients VARCHAR(1000)
> DECLARE @smessage VARCHAR(1000)
> DECLARE @ssubject VARCHAR(100)
> DECLARE @ErrorNum INT
> DECLARE @ErrorMessage VARCHAR(500)
> DECLARE @ProcessID VARCHAR(30)
> DECLARE @ProcessStatus CHAR(1)
> DECLARE @Source VARCHAR(1000)
>
> SET @Source = 'spr_Email_DataTransferComplete'
> SET @ErrorNum = 0
> SET @ssubject = 'Cognos Data Transfer Completed'
> SET @srecipients = 'XXXX Powerplay Users'
> SET @sMessage = 'All,
>
> The Cognos data transfer completed at - ' + CONVERT(VARCHAR, GETDATE()) +
> '.
> The portal reports will be avaialable at - ' + CONVERT(VARCHAR,
> DATEADD(MI,
> 40, GETDATE())) + '.
> The cubes will start updating now and will finish in approximately 5hrs.
>
> For any issues please log a call with the ServiceDesk.
> This is an automated email, please do not reply.
>
> Thank You'
>
> IF (SELECT DATEPART(DW, GETDATE())) <> 7
> BEGIN
> EXEC @ErrorNum = Master..xp_sendmail
> @recipients = @srecipients,
> @subject = @ssubject,
> @message = @smessage
> END
>
> IF @ErrorNum <> 0
> BEGIN
> SET @ErrorMessage = 'Failed to Send Email'
> GOTO ERROR
> END
>
> -- No Error
> NOERROR:
> SET @OutRetVal = @ErrorNum
> RETURN(@ErrorNum)
>
> -- Error Handling
> ERROR:
> EXEC GG_JDE.dbo.sp_Log
> @Type = 'E',
> @Source = @Source,
> @Message = @ErrorMessage
> SET @OutRetVal = @ErrorNum
> RETURN(@ErrorNum)
> GO
>