Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
USE [ReefJunkies] GO /****** Object: StoredProcedure [dbo].[Proc_MailQue] Script Date: 11/17/2010 23:34:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Proc_MailQue] AS DECLARE @EmailRecipient VARCHAR(50); DECLARE db_cursor CURSOR FOR SET @EmailRecipient = (SELECT ToAddress from dbo.MailQueue WHERE (HasSent=0)); OPEN db_cursor; FETCH NEXT FROM db_cursor INTO @EmailRecipient; WHILE @@FETCH_STATUS=0 BEGIN EXEC msdb.dbo.sp_send_dbmail @recipients=@EmailRecipient, @subject = 'Subject', @body = 'body', @body_format = 'HTML', @profile_name='Reef Junkies'; UPDATE MailQueue SET HasSent = 1 WHERE (HasSent = 0) AND (MailqueueID = @MailqueueID) FETCH NEXT FROM db_cursor INTO @EmailRecipient; END CLOSE db_cursor; DEALLOCATE db_cursor; DELETE FROM MailQueue WHERE DateStamp < GETDATE()- 90
Join the community of 500,000 technology professionals and ask your questions.