Microsoft KB Archive/248229
Article ID: 248229
Article Last Modified on 7/31/2001
- Microsoft Office 2000 Developer Edition
This article was previously published under Q248229
If you schedule too many jobs to occur at the same time, some scheduled jobs may fail.
The Microsoft Access Workflow Designer workflow engine works best when you schedule 10 or fewer jobs at any one time. If you schedule more jobs, some jobs may fail. For example, if your Access Workflow Designer solution has 20 to 30 publication jobs, a user list synchronization job, and a workflow timeout job all set to run at midnight daily, the jobs at the bottom of the list (usually the user list synchronization and workflow timeout jobs) may fail. In addition, the server begins to run low on virtual memory.
Reschedule some jobs for other times so that 10 or fewer jobs run at any one time.
Additional query words: sqlserveragent userlist user list timeout prb
Keywords: kbprb kbworkflowdesigner KB248229