Are there limitations on the number of workflow rules that can be triggered simultaneously for my org?
Here's the situation. My company is running as Unlimited with between 100 - 200 users. My manager is trying to come up with a way to simulate recurring scheduled tasks for a custom object in Salesforce. Before we put it into play, I'm trying to determine if we'll run into any Salesforce limits that will cause trouble.
Here's what we're trying to do:
- I will write an external script that accesses Salesforce via the API.
- Every hour, this script checks a checkbox on every records of a custom object.
- Our Salesforce declarative interface guy will set up a workflow on these records that is triggered by the change in state of the same checkbox:
- One workflow action unchecks the checkbox so that my script can re-check again it in an hour.
- He will add other workflow actions to schedule time-based actions for email notifications, update fields, etc...
There are thousands of records which this will apply to.
I've read through the Salesforce Limits Quick Reference Guide [PDF] and searched through this forum and others, but I haven't found a conclusive answer. I'm fairly new to Salesforce, and I've had a lot of trouble trying to decipher the Salesforce documentation.
Also, are there any recommendations for a better way to implement recurring tasks? I've seen a little info on scheduled APEX, but I haven't looked into it much. I know there are limits involved there as well.
Update: Solution in the comments on Doug B's answer.