Posted - 02/17/2014 : 21:26:26
| I have a stored procedure which has 2 parameters @LastUpdateDate and @CurrentDate
I calculate the difference between these two days and store it in another variable called Sub, like this
declare @sub int
select @sub = (datediff(dd,@LastUpdate,@CurrentDate))
If the value of Sub is greater than 0, I want to send an email notification to few people that the cube has not been refreshed since last day.
Can any one tel me how I can achieve this ? I researched about configuring sqldbmail, but that didn't work for me.
Any help would be greatly appreciated