in mare ar trebui ceva de genul (cu completarile respective):

DECLARE @DataFinalizareContract datetime, @idContract int
declare @cinetrimite varchar(50),@cineprimeste varchar(50),@Mesaj varchar (250)

DECLARE contract_cursor CURSOR FOR
SELECT idcontract,datafinalizarecontract FROM Contract
--WHERE idcontract is not null
--ORDER BY idcontract

OPEN contract_cursor

FETCH NEXT FROM contract_cursor
INTO @DataFinalizareContract, @idContract

WHILE @@FETCH_STATUS = 0
BEGIN

IF ---conditia daca mai sunt 4 zile pana la DataFinalizareContract
BEGIN
 select @cineprimeste = mail from Contract (mailul pt respectivul IDContract)
  exec sp_SMTPMail @cinetrimite, @cineprimeste,'Date Contract',@Mesaj

ELSE

 --- nu ar trebui sa faca nimic doar sa treaca la urmatorul IDContract sa compare data cu getdate()

   FETCH NEXT FROM contract_cursor
   INTO @DataFinalizareContract, @idContract
END

CLOSE contract_cursor
DEALLOCATE contract_cursor
GO

multumesc mult

alex.