You can do this by your DataBase try this code.
You need SSIS to call a stored procedure every period of time.
Please check this for the stored procedure (I got it from here: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21944312.html):
CREATE PROCEDURE [dbo].[PROC_CDOMAILALERTS]
@From varchar(200),
@To varchar(200),
@ReplyTo varchar(200),
@Cc varchar(200),
@ArchiveId varchar(200),
@SMTPServer varchar(100),
@Subject varchar(200) = " ",
@Body varchar(4000) = " "
AS
BEGIN
Declare @iMsg int
Declare @hr int
Declare @ht int
Declare @source varchar(255)
Declare @description varchar(500)
Declare @output varchar(1000)
Set @ArchiveId = @ReplyTo + ',' + @ArchiveId
EXEC @hr = sp_OACreate 'CDO.Message', @iMsg OUT
EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusing").Value','2'
EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', @SMTPServer
EXEC @hr = sp_OAMethod @iMsg, 'Configuration.Fields.Update', null
EXEC @hr = sp_OASetProperty @iMsg, 'To', @To
EXEC @hr = sp_OASetProperty @iMsg, 'ReplyTo', @ReplyTo
EXEC @hr = sp_OASetProperty @iMsg, 'Cc', @Cc
EXEC @hr = sp_OASetProperty @iMsg, 'BCc', @ArchiveId
EXEC @hr = sp_OASetProperty @iMsg, 'From', @From
EXEC @hr = sp_OASetProperty @iMsg, 'Subject', @Subject
EXEC @hr = sp_OASetProperty @iMsg, 'TextBody', @Body
EXEC @hr = sp_OAMethod @iMsg, 'Send', NULL
EXEC @ht = sp_OADestroy @iMsg
RETURN @hr
END
link [
^]