Question

Photo of Josh LeVeque

0

Rock Cleanup Job

1

I made some adjustments to our retention period for interactions and it seems to be causing our Rock Cleanup job to stall out/fail.

The Jobs Administration screen shows a last status message of "Old interactions..." but it never gets past that point.

I did a sql query of my interactions based on the year and the old ones aren't dropping out. I have over 500K that should drop off based on the adjusted retention periods.

Is there a safe alternate way to clear some of these old interactions that are clogging things up. v15.5.

Thanks,

Josh

  • Photo of Daniel Hazelbaker

    0

    Couple ideas:

    1. You might try putting the retention period back the way it was, make sure the job finishes and then lower the retention period bit by bit. In other words, if you are going from say 365 down to 30, try going to 325 first and let the job run, then down to 300, etc.

    2. If you are running on Azure SQL Database, you might need to beef it up for a day or two while this process runs. Sometimes these kinds of large/bulk cleanup operations can be very taxing on the SQL server and require more horsepower than you would otherwise give it.

    3. I would say there is no "safe" alternate. You can manually go into SQL and delete the records yourself, but you assume all risk if you mess something up. That said, the query you run is probably exactly what the Cleanup job is doing so you'd probably be stuck in the same boat.