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 |
