Не подгоняйте Творца!

А если через SQL Mail, запуская сторед процедуру из джоба?

Например, так:

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' and id = object_id('dbo.SUBSCRIPTION'))
DROP TABLE dbo.SUBSCRIPTION
GO

create table dbo.SUBSCRIPTION
(
sub_id int identity primary key clustered,
user_id int not null,
topic_id int not null
)
GO

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' and id = object_id('dbo.MAIL$SendEventBySubscription'))
DROP Procedure dbo.MAIL$SendEventBySubscription
GO

create procedure dbo.MAIL$SendEventBySubscription
@recipient varchar(200),
@message varchar(200)
AS
declare @ret int,
@sub_id int,
@user_id int,
@topic_id int

exec @ret = xp_startmail 'janetl', 'abc12345'
if @@error <> 0 goto Err

select @sub_id = 0

while( 1=1 )
begin
select top 1
@sub_id = sub_id,
@user_id = user_id,
@topic_id = topic_id
from SUBSCRIPTION
where sub_id > @sub_id
order by sub_id
if @@rowcount = 0 break

<Получаем в @recipient адрес пользователя по @user_id и в @message УРЛ по @topic_id>

exec @ret = xp_sendmail
@recipients = @recipient,
@message = @message,
@subject = 'Сообщеньице от SQL.RU'
if @@error <> 0 goto Err
end

exec @ret = xp_stopmail
if @@error <> 0 goto Err

return 0
Err:
return -1
go