Knowledge Base

BUG: Weekly Tasks May Ignore Scheduled Interval

Article ID: 187880

Article Last Modified on 10/3/2003

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