There will never be a specific time as some of your affiliates will become active after a certain amount of time and others might never become active. I would suggest only sending PSA/CSA mails to them every week as it has been shown that a lot of affiliates use other email addresses and not there primary email address, so don't spend to much time sending emails, but never stop to pursue affiliates.