Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/248229

From BetaArchive Wiki
Knowledge Base


MOD2000: Too Many Jobs Scheduled for the Same Time Cause Some Jobs to Fail

Article ID: 248229

Article Last Modified on 7/31/2001



APPLIES TO

  • Microsoft Office 2000 Developer Edition



This article was previously published under Q248229

SYMPTOMS

If you schedule too many jobs to occur at the same time, some scheduled jobs may fail.

CAUSE

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.

RESOLUTION

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