BUG: Tasks Scheduled for Every N Days Runs Daily

Q155583

The information in this article applies to:

SYMPTOMS

The tasks scheduled to run every N days runs daily after the first execution.


WORKAROUND

Instead of using a daily task to run on alternate days or every N days, use a weekly task to run on specified days (for example: Monday, Wednesday, Friday and Sunday).


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: schedule task incorrect execution

Keywords : kbnetwork
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600


Last Reviewed: April 3, 1999
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.