Trying to accomplish what's described here:

https://technet.microsoft.com/en-us/library/ee534907%28v=ws.10%29.aspx?f=255&MSPPError=-2147217396#BKMK_ConfigureRenewalRequests

I'm pretty sure it was working couple of months ago, but now when change the date cert_renew column in the dbo.Certificates -table, nothing happens... there isn't an email sent and I cannot figure out why.

Also, when logging to the portal with the cm update service account, there isn't a renewal request made at all... any ideas where to start checking?

Got this one figured out, the Profile Template I tested earlier was added to %ProgramFiles%\Microsoft Forefront Identity Manager\2010\Certificate Management\Bin\Microsoft.Clm.Service.exe.config -file on the <add key=CLM.Service.RenewalService.OnlineUpdateProfileTemplates value=template/> and the new one I tested with wasn't.

Simply adding the template name for value separated with semicolon did the trick and renewal request was made, one-time passwords distributed for the target were emailed.

This was pretty hiddenly explained on the same page I posted earlier: https://technet.microsoft.com/en-us/library/ee534907%28v=ws.10%29.aspx?f=255&MSPPError=-2147217396#BKMK_ConfigureOnlineUpdates