• Do you have a DATETIME column on the table? You would need it to delete rows older than 30 minutes. To do that you can use the DATEADD function in your where clause.

    DELETE FROM dbo.YourTable WHERE Condition=100 AND YourTimeColumn < DATEADD(MINUTE, -30, GETDATE())