USE SRO_VT_SHARD GO DECLARE @CharName Varchar (MAX) DECLARE @CharID INT SET @CharName = 'Rival' SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName) DELETE FROM _TimedJob WHERE CharID = @CharID