Create PROCEDURE CleanupJob
        @NoDays int = 800
AS
BEGIN

       DECLARE @JobStartDateTime DATETIME = getutcdate()
--Clean records older than 800 days
       DECLARE @rowcount int
       SELECT @rowcount = 1
       WHILE @rowcount > 0 BEGIN
             DELETE top (100) [DB].[INSTANCE].[TABLE_DETAIL]
             where [Event_ID] IN
             (SELECT [Event_ID] FROM [DB].[INSTANCE].[TABLE])
             WHERE start_time <  DATEADD(day, -@NoDays,@JobStartDateTime)
                                                    SELECT @rowcount = @@ROWCOUNT
       END
END
GO