2022.2

Forexample,ifyourlongestjobtakes45to50minutestorun,thensetthe
retentiontimeto55minutes(or1hour)toensurethatallthedatabaseobjects
createdduringjobprocessingsurviveforthedurationofthejob.
l
Minimum time to retain Content Sets:TheminimumtimeaContentSet(andall
thecontentitemsitcontains)isretainedwithinthedatabasebeforebeingsetfordele-
tion.
l
Minimum time to retain Job Sets:TheminimumtimeaJobSet(andallthejobs
informationitcontains)isretainedwithinthedatabasebeforebeingsetfordeletion.
l
Minimum time to retain Managed Files:Theminimumtimefilereferences(tofiles
suchasdatamappingconfigurationsandtemplates)areretainedwithinthedata-
basebeforebeingsetfordeletion.
l
Minimum time to retain other entities:Theminimumtimeanyorphaneddata
(suchasFinishingtables,Mediatables,DataModelsandPropertiestables)are
retainedwithinthedatabasebeforebeingsetfordeletion.
l
Database Partition Settings:
l
Use Database Partitioning:SelecttouseDatabasePartitioning.
l
Empty partition count:Thenumberofemptypartitionsthatarecreatedeachclean-
uprun.Thisdefaultsto24.
l
Partition Size:Enterthelengthoftimebeforepartitionsareswitched.Thiscanbe
enteredinminutes,hours,days,weeksormonths.
l
File Clean-up Service:
l
Allow file clean-up service:Checktoautomaticallydetectorphanfilesandsetthemfor
deletion.OrphanfilescouldberesourcesandinternalfilesusedbyConnect,butwhichare
notneededbyanyrunningjob.
l
Minimum time to retain orphaned files:Theminimumtimeduringwhichorphaned
filesarekeptinthedatabasebeforebeingsetfordeletion.
TheClean-upServicespreferencesalsoprovidesyouwithbuttonsto:
l
Run Now:Thiswillruntheclean-upserviceimmediately.
l
Restore Defaults.ThisoptionrestoresthepreferencestoDefaults.Thisappliestothecurrent
Preferencespageonly,butnototherPreferences.
l
Apply:ThisoptionappliesthesettingsmadewithinthecurrentPreferencespage,butdoesnot
closethePreferencesdialog.
Page 350