We have a workflow that is pretty simple. It queries a SQL table looking for a Null Value and greater than 7 days of the notification date. If the value is just Null it immediately sends an email. We run it daily. The problem is when we send this email over 1000 people try to access the Forms at once and they get a loading page. (This is a separate issue we are working through with our VAR and another post here on LF Answers)
I'm looking for ideas to send the email to the remaining 6k+ employees without directing them to the Form at once. Maybe batch it together or set some kind of delay that runs every so many mins while working through the list. Delay in Workflow is 1 min to it would take 4 days to notify the end users. We have a hard 3 day max to notify employees.
I don't think I can go back in and add anything to the table because of the other 2k responses and I'm not a database guy. Any suggestions would be greatly appreciated.