1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| DECLARE @SRID int, @SRTitle nvarchar(255) ,@BUAnalyst nvarchar(255), @ProjectLeader nvarchar(255), @ReviewDate datetime
DECLARE curC CURSOR FOR
SELECT ... /* La requete me permet de recuperer les infos dont j'ai besoin */
OPEN curC
FETCH curC INTO @SRID, @SRTitle, @BUAnalyst, @ProjectLeader, @ReviewDate
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @TextBody nvarchar(max)
DECLARE @TextSubject nvarchar(max)
SET @TextSubject = 'SR' + CONVERT(nvarchar(max), @SRID ) + ': Review date reminder'
SET @TextBody = 'Your SR' + CONVERT(nvarchar(max),@SRID) + ' ' + @SRTitle + ' will be reviewed on ' + CONVERT(nvarchar(max),@ReviewDate )
EXEC msdb.dbo.sp_send_dbmail
@recipients = @BUAnalyst,
@copy_recipients = @ProjectLeader,
@body = @TextBody,
@subject = @TextSubject
FETCH NEXT FROM cur
END
CLOSE curC;
DEALLOCATE curC;
GO |
Partager