List pruned jobs

Question

Hi,

I hope this would be a quick and easy question. Is there any report that show me the list of jobs pruned in a data aging task in a specific time?

I read this topic and be able to view what is to be pruned, but what was pruned yesterday by example?

Thanks

Mike Struening · Accepted Answer

Hi@MTejedor!We do not have that ability to show this in a report. However, Inside the SQL table called JMJobDataStats and a column that references "agedBy" and depending what code is displayed, translates to how the job was aged.The AGED_BY flags for the agedBy column in archChunk, archChunkMapping, archFileCopy and JMJobDataStats tables.CVA_AGED_BY_RULES 512CVA_AGED_BY_PRUNE_JOB 1024CVA_AGED_BY_DEL_ARCHFILE 2048CVA_AGED_BY_DEL_CONTENT 4096CVA_AGED_BY_OVERWRITE 8192CVA_AGED_BY_KILL_FAIL 16384CVA_AGED_BY_SPOOL_AGING 32768CVA_AGED_BY_WATER_MARK 65536CVA_AGED_BY_RECOPY_MEDIA 131072CVA_AGED_BY_UTILITY 262144CVA_AGED_BY_DANGLING 524288CVA_AGED_BY_DEL_APP 1048576CVA_AGED_BY_CLEANJOBCOPYWITHOUTAF 2097152CVA_AGED_BY_SILOPRUNING 4194304CVA_AGED_BY_EXTERNALPRUNING 8388608CVA_AGED_BY_SNAPPRUNING 16777216CVA_AGED_BY_CLEAN_AGED_MEDIA 33554432CVA_AGED_BY_TAPE_IMPORT 67108864CVA_AGED_BY_MEDIA_REFRESHING 134217728CVA_AGED_BY_DEL_POLICY_COPY 268435456CVA_AGED_BY_FOREIGN_JOB_DISCOVERY 536870912CVA_UNAGED_JOB 1073741824CVA_AGED_BY_DEL_INVALID_CHUNKS 2147483648CVA_AGED_BY_TRANSITIVE_COPY_SRC_DEL 4294967296CVA_AGED_BY_INDEX_PRUNING 8589934592CVA_AGED_BY_AUXCOPY 17179869184CVA_AGED_BY_COMBINEDSTREAM 34359738368CVA_AGED_BY_RECOPY 68719476736CVA_AGED_BY_EDGE_SYNTHFULL 137438953472Let me know if that helps!

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded