Workflow tasks not scheduling as expected
When workflow tasks are not scheduling as expected, or workflows aren't firing at all, perform the following troubleshooting actions:
Enable Service Broker
Service Broker must be enabled in order for workflows to fire properly. To check if Service Broker is enabled on your database, run the following script against the Master database in SQL Management Studio:
SELECT name, is_broker_enabled FROM sys.databases order by name
- Is_broker_enabled should have a value of 1 (yes) for your database.
- If is_broker_enabled = 0 (no), you will need to enable it. Have all users log out of the system and run the following script against your database:
exec EnableServiceBroker
When the script has finished running, verify Service Broker has been enabled by using the first script again.
Check Auto Scheduling Cutoff Date
Confirm that the Auto Scheduling Cutoff Date has not been set in the future.
- Go to Setup > System > Evolv CS System Setup > System Settings/Preferences.
- Check the Auto Scheduling Cutoff Date field. If populated with a future date, simply update the field and save the changes.
Note: When the Auto Scheduling Cutoff Date is populated, the system filters what past events can be used as a basis for scheduling future events. No events prior to the Auto Scheduling Cutoff Date will fire future workflows.
