Job limitar numero de resets por dia

ALTER TABLE dbo.[Character] ADD
Rdia int NOT NULL CONSTRAINT DF_Character_Rdia DEFAULT 0
GO

UPDATE Character
SET 
Rdia   = 0

----------------------WWW.ZONEGAMES.COM.BR----------------------
------ Limitando o numero de reset de contas Free por dia-------
--------------------------By llZeZoll---------------------------

declare @limite_resets_dia int
declare @pontos int
declare @zen int
declare @level int
-------------------------- Variaveis ---------------------------

set @limite_resets_dia = 20       -- Limite de Resets por dia
set @pontos = 200                 -- Pontos por Resets
set @zen    = 20000000            -- Zen requerido
set @level  = 350                 -- Level requerido
 
-----------------------------------------------------------------


UPDATE Character

SET cLevel   = 1,
Experience   = 0,
LevelUpPoint = @pontos + @pontos * Resets,
Strength     = 25,
Dexterity    = 25,
Vitality     = 25,
Energy       = 25,
Leadership   = 35,
Money        = Money - @zen,
Resets       = Resets + 1,
Rdia         = Rdia + 1

FROM Character
JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS

WHERE cLevel > @level
AND Money > @zen
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0
AND Rdia <= @limite_resets_dia

-------------------MANTENHA OS CREDITOS ZONEGAMES---------------

----------------------WWW.ZONEGAMES.COM.BR----------------------
------ Limitando o numero de reset de contas Free por dia-------
--------------------------By llZeZoll---------------------------
--------------------------Acumulativo---------------------------

declare @limite_resets_dia int
declare @zen int
declare @level int
-------------------------- Variaveis ---------------------------
 
set @limite_resets_dia = 20       -- Limite de Resets por dia
set @zen    = 20000000            -- Zen requerido
set @level  = 350                 -- Level requerido
 
-----------------------------------------------------------------


UPDATE Character

SET cLevel   = 1,
Experience   = 0,
Money        = Money - @zen,
Resets       = Resets + 1,
Rdia         = Rdia + 1

FROM Character
JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS

WHERE cLevel > @level
AND Money > @zen
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0
AND Rdia <= @limite_resets_dia

-------------------MANTENHA OS CREDITOS ZONEGAMES---------------

UPDATE Character
SET 
Rdia   = 0