DECLARE @p_body as nvarchar(max), @p_subject as nvarchar(max) DECLARE @p_recipients as nvarchar(max), @p_profile_name as nvarchar(max) SET @p_profile_name = 'Mail' SET @p_recipients = N'foo@mail.com' SET @p_subject = N'This is a test mail using sp_send_dbmail 228' SET @p_body = 'This is an HTML test email send using <b>sp_send_dbmail</b>.' EXEC msdb.dbo.sp_send_dbmail @profile_name = @p_profile_name, @recipients = @p_recipients, @body = @p_body, @body_format = 'HTML', @subject = @p_subject

http://www.kodyaz.com/articles/sql-server-database-mail-sp_send_dbmail-example.aspx

check a repliation server date and send an email if it older then 1 day DECLARE @a int DECLARE @v CURSOR SET @v = CURSOR FOR select DATEDIFF(day,CONVERT(datetime,CAST(date as varchar(8)),112),GETDATE()) as date FROM SQL228.[SL].[dbo].[zz_version] as s OPEN @v FETCH NEXT FROM @v INTO @a IF @a > 1 BEGIN DECLARE @p_body as nvarchar(max), @p_subject as nvarchar(max) DECLARE @p_recipients as nvarchar(max), @p_profile_name as nvarchar(max) SET @p_profile_name = 'Mail' SET @p_recipients = N'foo@bar.com' SET @p_subject = N'ALERT! Replication server 228 is' +CONVERT(VARCHAR,@a) +' days old' SET @p_body = N'Replication server 228 is <b>' +CONVERT(VARCHAR,@a) +'</b> days old' EXEC msdb.dbo.sp_send_dbmail @profile_name = @p_profile_name, @recipients = @p_recipients, @body = @p_body, @body_format = 'HTML', @subject = @p_subject END 14.10.17

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024