I once developed an email alert workflow rule which sends mail to the respective owner of an application whose application's status is still in "New" status after 3 days of creating it. I used batch apex to fetch all those records and made a checkbox field "true" in the execute method which will be the triggering point of my workflow rule. This is how i have developed that functionality.