• I want to put a final note on here in case someone comes across this in the future. I researched the min_xact_seqno number that wasn't returning any rows in my above query. This lead me to the MSrepl_commands table, which based on agent_id lead me to the MSdistribution_agents table. From here I figured out which job was causing the issues. I was able to see that our developers had decided they only needed to replicate from a set of tables once a month, because they only loaded data once a month. The Replication had expired on for the job because it hadn't been run for so long, so I scripted out and dropped it. When I re-ran the clean up job, it deleted over 175 Million records from the MSrepl_commands table.