I have a business requirement to send email alert 7 days after Opportunity Close Date @ 9 AM CET time. But i dont see any option where I can specify time or hours in Process Builder. I see option for number of days only. Does anybody know if we can send email alerts at a specific time or not using Process Builder Flows.
From what I know of time-based workflow/Process Builder flow, the units of time supported to schedule an action are days and hours and not a particular time.
A programmatic approach would help you to deliver the requirement. You can create a schedulable class, which runs a batch apex at 9 AM CET every day. In the batch class, you can query the opportunities closed 7 days ago (within 24 hours on the 7th day) and send an email. Few references and hints to help you go ahead.
1> you can use
N_DAYS_AGO : 7 criteria in start method query in the batch job
SingleEmailMessage class and methods to send emails