Activity- Database Connect issue

not sure which orchestration version allows this to set the retention policy for logs but it should be there in this file UiPath.Orchestrator.dll.config file..

but the best way to manage logs as of now seems to be like i suggested to have a SSMS SQL agent to be triggered on some specific condition over night.
please see the discussion in this thread : Deleting Logs

hope this helps.

SG.