However after monitoring REFRDEL for a couple of weeks, we found that REFRDEL_CLEANUP was actually running and removing data from the table. We first assumed that this was preventing the REFRDEL_CLEANUP from running.
This was due to an offline backup process which started at 10pm. ĭAMON runs the following procedures to perform clean-up:ĭAMON was configured to run every Saturday around 4pm but we noticed that it had been continuously failing. We noticed REFRDEL had grown to a large size and after some investigation discovered the following. If the Primavera background processes (SYMON and DAMON) are not listed, or the SQL Agent was not started, then these background processes can be reinitialized by running the following commands as SA user against the Project Management database:Ī bit late coming to this, but thought the following may be useful to some. If the SQL Agent is started, you can then check what jobs exist on the SQL Server database by issuing the following command as SA through SQL Query Analyzer (2000) or through Microsoft SQL Server Management Studio: