Microsoft KB Archive/187880

= BUG: Weekly Tasks May Ignore Scheduled Interval =

Article ID: 187880

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q187880



SYMPTOMS
Recurring tasks which have been scheduled for Weekly execution on a Saturday, will ignore the interval specified and will schedule the task to run every week. For example, if the task is scheduled to run every 3 weeks it will actually be submitted every week.



WORKAROUND
To work around this problem, change the task scheduling to Daily, starting on a Saturday, and multiply the desired weekly interval by 7. For example, if you wanted a Weekly task to run every 3 weeks on a Saturday, amend the schedule so that it runs Daily every 21 days with a Start Date of Saturday.



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



MORE INFORMATION
This problem only happens to Weekly tasks that are scheduled to run on a Saturday. For all other days of the week (Sunday through Friday), the specified interval is correctly scheduled.

The number of weeks specified in the interval makes no difference. The interval used will be 1, regardless of the number entered. You can identify the scheduled dates by running the following query in ISQL/w:

select name, lastrundate, nextrundate from msdb..systasks

Note that when this problem occurs, an incorrect "nextrundate" is set for the relevant task.

Additional query words: prodsql SQL Executive Scheduler Task Manager Job

Keywords: kbbug kbpending KB187880

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.