DECLARE @id nvarchar(MAX), @Counter int, @CheckCount int DECLARE CC1 CURSOR READ_ONLY FOR SELECT Ename, Ecount FROM TestDB.dbo.TestEmail OPEN CC1 FETCH NEXT FROM CC1 INTO @id, @Counter WHILE @@FETCH_STATUS = 0 BEGIN Begin EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Boom', @recipients = @id, @body = 'The stored procedure finished successfully. #$%', @subject = 'Automated Success Message' ; update TestDB.dbo.TestEmail set Ecount=Ecount+1 where Ename=@id print @id END Select @CheckCount= Ecount from TestDB.dbo.TestEmail where Ename=@id print @CheckCount If @CheckCount > 3 Begin exec msdb.dbo.sp_update_job @job_id = N'6a81d6b3-af2d-4a27-b688-b9c69098f840', @enabled = 0 return PRINT 'Count reached 3+' End FETCH NEXT FROM CC1 INTO @id, @Counter END CLOSE CC1 DEALLOCATE CC1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)